Re: LookupSQL and Indexes

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

Article #1335

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

#1335

From: Bowen Moursund
Date: Wed, 04 Feb 1998 00:00

17 lines
1221 bytes

>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?

Perhaps not <g>. The BDE generally wants to work with simple indexes. If you
want to specify the use of a specific index tag:

q = new query()
q.sql = "select * from MYTABLE"
q.rowset.indexName = "TAGNAME"
q.active = true
__
Bowen Moursund (TeamB)
bowen.NOSPAM@nerds.com
http://www.mindspring.com/~bowenm/datatech.htm

Technical Details

Message-ID: <6ba901$7o14@forums.borland.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>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,ffda3a0d031bab69
X-Google-Attributes: gidff5a1,public
From: "Bowen Moursund" <teamb@opto-pps.com>
Subject: Re: LookupSQL and Indexes
Date: 1998/02/04
Message-ID: <6ba901$7o14@forums.borland.com>
X-Deja-AN: 322047013
Content-Transfer-Encoding: 7bit
References: <34D7D3FE.91E89A6D@VolSoft.com> <01bd3178$d4ad36c0$1030f489@jyuzamas.robins.af.mil> <34D887A5.C9529277@VolSoft.com>
Content-Type: text/plain; charset="iso-8859-1"
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Organization: DataTech
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message