Re: LookupSQL and Indexes

Article View: borland.public.vdbase.data.sql

Article #1337

Back to borland.public.vdbase.data.sql Previous Next

#1337

From: Lane Coddington
Date: Wed, 04 Feb 1998 00:00

20 lines
1241 bytes

Steve,

Thanks. Your response (and Bowen's) makes it a lot clearer.


Steve Koterski wrote:
> 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).

-- 
Lane Coddington
Volunteer Software
Lane@VolSoft.com

Technical Details

Message-ID: <34D8F01C.E445D8A4@VolSoft.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References:

<34D7D3FE.91E89A6D@VolSoft.com> <01bd3178$d4ad36c0$1030f489@jyuzamas.robins.af.mil> <34D887A5.C9529277@VolSoft.com> <34d9a630.3637531@forums.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,ffda3a0d031bab69
X-Google-Attributes: gidff5a1,public
From: Lane Coddington <Lane@VolSoft.com>
Subject: Re: LookupSQL and Indexes
Date: 1998/02/04
Message-ID: <34D8F01C.E445D8A4@VolSoft.com>
X-Deja-AN: 322126484
Content-Transfer-Encoding: 7bit
References: <34D7D3FE.91E89A6D@VolSoft.com> <01bd3178$d4ad36c0$1030f489@jyuzamas.robins.af.mil> <34D887A5.C9529277@VolSoft.com> <34d9a630.3637531@forums.borland.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Organization: Volunteer Software
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message