Re: LookupSQL and Indexes

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

Article #1331

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

#1331

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

23 lines
1263 bytes

Joe,

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.

-- 
Lane Coddington
Volunteer Software
Lane@VolSoft.com

Joe Yuzamas wrote:
> 
> 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 >
>

Technical Details

Message-ID: <34D887A5.C9529277@VolSoft.com>

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

References: <34D7D3FE.91E89A6D@VolSoft.com> <01bd3178$d4ad36c0$1030f489@jyuzamas.robins.af.mil>

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: <34D887A5.C9529277@VolSoft.com>
X-Deja-AN: 322009201
Content-Transfer-Encoding: 7bit
References: <34D7D3FE.91E89A6D@VolSoft.com> <01bd3178$d4ad36c0$1030f489@jyuzamas.robins.af.mil>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Organization: Volunteer Software
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message