Re: LookupSQL and Indexes

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

Article #1340

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

#1340

From: Joe Yuzamas
Date: Thu, 05 Feb 1998 00:00

33 lines
1659 bytes

Bob - Although I have never tested that, I suspect that is what would
happen. I would never use the order by for an answer set I expected to
edit. Use indexes where you anticipate editing. 
-- 
Joe  < jyuzamas@wrdiss1.robins.af.mil or jyuzamas@sprynet.com >

Robert L. Buchanan <47420.1311@compuserve.com> wrote in article
<01bd320e$6f333600$83e6afce@bob-buchanan>...
> 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: <01bd3242$85d68220$1030f489@jyuzamas.robins.af.mil>

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

References:

<34D7D3FE.91E89A6D@VolSoft.com> <01bd3178$d4ad36c0$1030f489@jyuzamas.robins.af.mil> <01bd320e$6f333600$83e6afce@bob-buchanan>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,ffda3a0d031bab69
X-Google-Attributes: gidff5a1,public
From: "Joe Yuzamas" <jyuzamas@wrdiss1.robins.af.mil>
Subject: Re: LookupSQL and Indexes
Date: 1998/02/05
Message-ID: <01bd3242$85d68220$1030f489@jyuzamas.robins.af.mil>
X-Deja-AN: 322311334
References: <34D7D3FE.91E89A6D@VolSoft.com> <01bd3178$d4ad36c0$1030f489@jyuzamas.robins.af.mil> <01bd320e$6f333600$83e6afce@bob-buchanan>
Organization: U.S. Air Force
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message