Re: index skip scan

From: mathewbutler <mathewbutler_at_yahoo.com>
Date: Wed, 7 Jan 2009 14:33:21 -0800 (PST)
Message-ID: <bcdcc04a-8b38-4f83-a181-1daf0e4b69e1_at_u18g2000pro.googlegroups.com>

On Jan 7, 8:34 pm, "Matthias Hoys" <a..._at_spam.com> wrote:
> "jerni..._at_nospam.kochind.com" <jerni..._at_kochind.com> wrote in message
>
> news:26940461-199e-4d93-a8f0-8754a9f4bd8f_at_k1g2000prb.googlegroups.com...
>
> >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 ?
>
> Matthias

Use dbms_stats. Received on Wed Jan 07 2009 - 16:33:21 CST