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


> 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: 

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.



Other related posts: