Re: ADO MaxRows property and Oracle 7.3.4

From: Jeff Ashley <jeffashley_at_worldnet.att.net>
Date: Thu, 22 Jul 1999 18:49:18 -0400
Message-ID: <37979FEE.B9D03C63@worldnet.att.net>

But _not_ if you are ordering by an indexed field, right?

John Hurrell wrote:

> On Tue, 20 Jul 1999 08:01:14 -0400, Jeff Ashley
> <jeffashley_at_worldnet.att.net> wrote:
>
> >Yeah, but if you are ordering by primary key, there should be _zero_
> >difference! I don't work with Oracle, but there must be something getting
> >missed here . . .
>
> A primary key is merely a field that is guaranteed to be unique, not
> fast. An INDEX is a set of information about the physical location of
> data and therefore WILL speed performance.
>
> The bad news is, in either case using an ORDER BY clause will incur a
> performance hit because Oracle has to sort the recordset before it can
> return the first X number of records you request.
Received on Thu Jul 22 1999 - 17:49:18 CDT