Re: Index clustering factor
Date: Wed, 9 Jan 2008 15:22:29 -0800
On Jan 9, 2008 1:54 PM, Orysia Husak <Orysia.Husak_at_apollogrp.edu> wrote:
> When I generate an explain plan manually, the appropriate index is used.
> When I view the sql running through OEM, I see the execution plan is a
> full tablescan. Since the clustering factor for this index is very high,
> my assumption is that the index isn't being selected due to the high
> clustering factor.
Cluster factor should not come into play if only 1 or two blocks need to be read.
It seems as if you may have been unlucky, as in the SQL in the cache was
with values that required an FTS due to data skew.
One of the optimizer experts is sure to chime in here soon.
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 09 2008 - 17:22:29 CST