Yes, it turns out you are right. The table was parallelized and multiblock
read count was high. After reducing multiblock read count and removing the
parallelization, index was used.
Thanks
Ken Geis wrote in message <364A4DDC.24CA8AAD_at_cchemnt.cchem.berkeley.edu>...
> I can't believe that it does. You should post the results of an
>EXPLAIN PLAN. Note that sorting without indexes is not trivial for a
>large table.
>
>Ken
>
>
>Roman Gelfand wrote:
>>
>> I am trying to execute a select statement querying against a single table
>> without a where clause and sorting by two columns.
>>
>> Can anyone tell me why does this statement causes recursion when
executed?
>>
>> Thanks,
>>
>> Roman
Received on Fri Nov 13 1998 - 08:32:56 CST
