Re: vendor sql tuning

  • From: amit poddar <amit.poddar@xxxxxxxx>
  • To: cstephens16@xxxxxxxxx
  • Date: Fri, 15 Jul 2005 09:30:02 -0400

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:


Other related posts: