Re: LookupSQL and Indexes

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

Article #1338

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

#1338

From: Robert L. Buchanan
Date: Thu, 05 Feb 1998 00:00

21 lines
1185 bytes

Joe:

My tests seem to indicate that if no index exists, it sorts the table into
a temp table -- which makes it readOnly. If a tag exists, it uses it -- and
allows editing. What am I missing here?

Regards, Bob in Sacramento

Joe Yuzamas <jyuzamas@wrdiss1.robins.af.mil> wrote in article
<01bd3178$d4ad36c0$1030f489@jyuzamas.robins.af.mil>...
> 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: <01bd320e$6f333600$83e6afce@bob-buchanan>

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: "Robert L. Buchanan" <47420.1311@compuserve.com>
Subject: Re: LookupSQL and Indexes
Date: 1998/02/05
Message-ID: <01bd320e$6f333600$83e6afce@bob-buchanan>
X-Deja-AN: 322250826
References: <34D7D3FE.91E89A6D@VolSoft.com> <01bd3178$d4ad36c0$1030f489@jyuzamas.robins.af.mil>
Organization: RLB & Associates
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message