Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Select Statement

Re: Select Statement

From: Jim Kennedy <jim>
Date: Fri, 21 Apr 2006 08:30:11 -0700
Message-ID: <2vOdnY1NIPhtZNXZnZ2dnUVZ_vidnZ2d@comcast.com>

"eye1h" <eye1h_at_yahoo.com> wrote in message news:1145630740.287100.163020_at_u72g2000cwu.googlegroups.com...
> Hi Terry,
>
> 1) This will also go through the full table scan to get rows (transnum
> = :Itransnum)
> 2) Then the results will logically sequenced and results which are less
> the rownnum 2 will be displayed.
>
> This has the same problems like the original query.
>
> Cheers
> Ivan
>

if transnum is unique and meant to be unique then add a unique index or make it a hash table with a high number of hash entries. Having a single index isn't going to affect it that much. (probably not as much as those full table scans)
Jim Received on Fri Apr 21 2006 - 10:30:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US