[AccessD] Indexes on text fields

John Colby jcolby at colbyconsulting.com
Thu Aug 14 08:39:46 CDT 2003


Yep, I'm sure.

John W. Colby
www.colbyconsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jim Dettman
Sent: Thursday, August 14, 2003 8:33 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Indexes on text fields


John,

  <<Nope.>>

  Are you sure about that?  JET would certainly know about the base indexes
on those fields from the costing plan.  Then again, JET may build it's own
index for the query output.   Hard to say if you don't know the internals.

Jim Dettman
President,
Online Computer Services of WNY, Inc.
(315) 699-3443
jimdettman at earthlink.net

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John Colby
Sent: Wednesday, August 13, 2003 5:59 PM
To: Access Developers discussion and problem solving
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


_______________________________________________
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