LookupSQL and Indexes

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

Article #1326

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

#1326

From: Lane Coddington
Date: Tue, 03 Feb 1998 00:00

18 lines
1037 bytes

It doesn't seem that the SQL SELECT statement can use dBase indexes, but
then in the Help file under LookupSQL it says:

"The SQL SELECT statement may include the usual options; in particular,
you may want the table to be ordered on the lookup field (or use a table
where such an index is available) for faster lookups."

That makes it sound like the SQL SELECT statement can use indexes, but I
can't figure out how. Does SQL SELECT automatically use an index if it
matches the ORDER chosen?

Thanks.

-- 
Lane Coddington
Volunteer Software
Lane@VolSoft.com

Technical Details

Message-ID: <34D7D3FE.91E89A6D@VolSoft.com>

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

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,ffda3a0d031bab69,start
X-Google-Attributes: gidff5a1,public
From: Lane Coddington <Lane@VolSoft.com>
Subject: LookupSQL and Indexes
Date: 1998/02/03
Message-ID: <34D7D3FE.91E89A6D@VolSoft.com>
X-Deja-AN: 321862318
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Organization: Volunteer Software
Newsgroups: borland.public.vdbase.data.sql