Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Full table scan despite appropriate indexes
John, last time I tried with two hints separately and with one hint
only. It did not work.
The ordered option did not work either. In fact it took longer.
Now I tried with just one table as you said by hard coding the value for month_sk. It worked!
Now what? I am totally lost. I still dont understand why the optimizer is not picking up the indexes. Received on Wed Feb 07 2007 - 20:24:00 CST
![]() |
![]() |