🚀 go-pugleaf

Lane - The ORDER BY creates an internal index and sorts on that index. The
SELECT statement will automatically use indexes if available, but SQL does
not require them. You will get better response from indexed fields. You may
also create indexes from SQL.
-- 
Joe  < jyuzamas@wrdiss1.robins.af.mil or jyuzamas@sprynet.com >

Lane Coddington <Lane@VolSoft.com> wrote in article
<34D7D3FE.91E89A6D@VolSoft.com>...
> 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
>