RE: Table access prediction based on clustering factor

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Wed, 27 Sep 2006 12:05:00 +0200
Message-ID: <F2C9CCA71510B442AF71446CAE8AEBAF615B3A@MSXVS04.trivadis.com>

Bernard

> Obiously I can retrieve the min and max, but still given the same
> rowset if I am told that the CF is now 45% how does it translate ?

A long time ago (beginning 2001) I wrote a paper entitled "When should and index be used?" discussing such stuff. The link is: http://www.trivadis.com/Images/E_IndexStats_tcm17-7262.pdf

A couple of things on it, especially about DB_FILE_MULTIBLOCK_READ_COUNT, should be reviewed... but the rest, if I correctly remember, should be fine.

HTH
Chris

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 27 2006 - 05:05:00 CDT