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: select value within an interval

Re: select value within an interval

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 18 Apr 2006 06:53:11 -0700
Message-ID: <1145368391.507966.301360@t31g2000cwb.googlegroups.com> 





Why are you generating histograms on this table?  What happens to the
plans if you drop the statistics then regenerate the statistics without
histograms?



There is a huge difference between an equality test and a range.
Obviously with the between the CBO thinks that it will have to scan too
much of the table for the index to be useful.  The questions are why,
and is it right or wrong in that case?



What indexes are available to the CBO?



HTH -- Mark D Powell --
Received on Tue Apr 18 2006 - 08:53:11 CDT












Original text of this message













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