[AccessD] Indexes on text fields

Mark Whittinghill mwhittinghill at symphonyinfo.com
Wed Aug 13 13:33:03 CDT 2003


Let's say I have a Person table with FirstName and LastName fields.  Both
are non-unique indexed to help searches.  Now say I build a query with a
concatenated field FullName: LastName & ", " & FirstName.   Will the indexes
on these fields help speed searches on the FullName field?

Mark Whittinghill
Symphony Information Services
612-333-1311
mwhittinghill at symphonyinfo.com




More information about the AccessD mailing list