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