RE: Table access prediction based on clustering factor
- From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
- To: <Bernard.Polarski@xxxxxxxxxxxxxx>
- Date: Wed, 27 Sep 2006 12:05:00 +0200
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
Other related posts: