Re: index skip scan
Date: Wed, 7 Jan 2009 13:06:45 -0800 (PST)
On Jan 7, 2:34 pm, "Matthias Hoys" <a..._at_spam.com> wrote:
> "jerni..._at_nospam.kochind.com" <jerni..._at_kochind.com> wrote in message
> >I modified the clustering factor in my test environment and that fixed
> > the problem. I need to do more testing before moving into
> > production.
> > Thanks everybody for the help. I learned a lot though this.
> How did you modify the clustering factor ? Rebuild the index ?
Rebuilding the index won't change the clustering factor. Rebuilding the table or hacking the statistics will. I expect the stats were 'hacked' to reduce the value. Jonathan Lewis has provided a script showing how to hack the stats in the online code depot for his book 'Cost-Based Oracle Fundamentals' called, surprisingly, hack_stats.sql.
David Fitzjarrell Received on Wed Jan 07 2009 - 15:06:45 CST