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.
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: