Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Full table scan despite appropriate indexes

Re: Full table scan despite appropriate indexes

From: <aravind.kanda_at_gmail.com>
Date: 8 Feb 2007 08:57:04 -0800
Message-ID: <1170953824.159031.319000@m58g2000cwm.googlegroups.com> 





Finally I see some progress!!!



Without hint: (explain plan use FTS)



Predicate Information (identified by operation id):



PLAN_TABLE_OUTPUT








   2 - access("T2"."MONTH_SK"="T1"."DATE_SK")
   4 - access("T1"."YEAR_MONTH_CT"=200312)



With hint: (picked up the index)



 5 - access("T1"."YEAR_MONTH_CT"=200312)
 6 - access("T5"."MONTH_SK"="T1"."DATE_SK")



Is it the order that matters here? What can I do avoid using hints?
Why the optimizer is not picking the index when there is no hint?
Received on Thu Feb 08 2007 - 10:57:04 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US