Re: vendor sql tuning

Could you tell us what is the table structures and what columns are theses indexes present on.

Coluld you please also give us the tkprof rwosource operation too.

amit

Chris Stephens wrote:

>in spite of the odd responses, i'm still working on this if anyone has
>any suggestions.
>
>i simply cannot get it to use the index without full scanning it.
>...when i take the order by part out and hint it to use the index it
>still full scans
>
>i broke the sql down:
>
>
>

--
http://www.freelists.org/webpage/oracle-l