🚀 go-pugleaf

On Wed, 04 Feb 1998 08:22:13 -0700, Lane Coddington <Lane@VolSoft.com>
wrote:

>Thanks. So if I have a table with 3 tags in a production index, one of
>which is on UPPER( name ) and my SQL SELECT statement includes ORDER BY
>NAME, it will automatically use the table's index to speed up ordering
>of the SQL SELECT result? If so, that's cool.

Probably not. Local SQL (the SQL subset the BDE uses for dBASE and Paradox
tables) will use existing dBASE single-field primary and secondary indexes.
But it cannot use expression indexes to boost the speed of query result set
retrieval.

So if the ORDER BY clause references a NAME column, for an index to be used
it must be based on the NAME column only and use no dBASE data manipulation
language (DML) functions (like UPPER).

**************************************************************************
Steve Koterski
Borland International, Inc.
http://www.borland.com/delphi
(Remove the "SPICEDHAM2" from the address. Death to spam-bots!)