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...