"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
