Friday, October 14, 2005

Fully qualified names in MS Access query

Guys, did any of you ever noticed that in MS Access query written as inline ASP code using fully qualified names (like TableName.FieldName) [in SORT BY clause] makes it to work faster [in case a query joins more than one table]? I guess I saw it today. Maybe Access doesn't need to determine each time which table you're talking about... Or maybe I'm just dreaming...

Comments

Loading... Logging you in...
  • Logged in as
Login or signup now to comment.
There are no comments posted yet. Be the first one!

Comments by