Re: index CLUSTERING_FACTOR can be reduce

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: 16 Apr 2007 02:05:51 -0700
Message-ID: <1176714351.848995.281750@e65g2000hsc.googlegroups.com>

On Apr 16, 8:50 am, "peter" <hhh.datab..._at_gmail.com> wrote:
> is there any way to reduce CLUSTERING_FACTOR of any index.

sure, move all the data around in the base table to match the order in the index! That is , too condensed perhaps, what CF is telling you. There are however a number of sites that suggest that reducing the clustering factor of an index is a good performance tuning tip. It usually (like 98%+) of the time isn't.

Niall Received on Mon Apr 16 2007 - 04:05:51 CDT