RE: Clustering factor smaller than table blocks.

  • From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
  • To: <Bernard.Polarski@xxxxxxxxxxxxxx>
  • Date: Wed, 27 Sep 2006 10:59:59 +0200

Bernard

> I have a table with 368 blocks, no free blocks, and the clustering
> factor of the primary key is 345. how is it possible?

Since free blocks are not referenced by indexes they are not counted...


HTH
Chris
--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 09-2006