Re: Index clustering factor

From: Yong Huang <yong321_at_yahoo.com>
Date: 20 Jun 2002 21:18:08 -0700
Message-ID: <b3cb12d6.0206202018.58660873@posting.google.com>

dyou98_at_aol.com (D.Y.) wrote in message news:<f369a0eb.0206200843.5680d099_at_posting.google.com>...
> versa. As far as
> performance, I normally don't see a big improvement by tuning
> clustering factor, not
> more than a few percent. It could be because we have so much cache
> these days. You could

Have you done any test on a table that is scanned by parallel slaves, in which case Oracle buffer cache is allegedly bypassed? If that test still doesn't show difference, make sure you enabled filesystem direct I/O or used raw disks and test again.

Yong Huang Received on Thu Jun 20 2002 - 23:18:08 CDT