[AccessD] Indexes on text fields

Mark Whittinghill mwhittinghill at symphonyinfo.com
Wed Aug 13 17:23:21 CDT 2003


OK, thanks.

Mark Whittinghill
Symphony Information Services
612-333-1311
mwhittinghill at symphonyinfo.com
----- Original Message ----- 
From: "John Colby" <jcolby at colbyconsulting.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Wednesday, August 13, 2003 4:59 PM
Subject: RE: [AccessD] Indexes on text fields


> Nope.  Concatenated fields are just a text string to the query engine.
> However if you dragged the last and first name out into the query (even if
> hidden), then sorted on those fields, it would sort in that order (of
> course) and indexes on those fields would speed the sort.
>
> John W. Colby
> www.colbyconsulting.com
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mark
> Whittinghill
> Sent: Wednesday, August 13, 2003 2:33 PM
> To: accessd at databaseadvisors.com
> Subject: [AccessD] Indexes on text fields
>
>
> 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
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>




More information about the AccessD mailing list