Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> estimated of CLUSTERING_FACTOR

estimated of CLUSTERING_FACTOR

From: Andrea <netsecurity_at_tiscali.it>
Date: Wed, 05 Sep 2007 04:09:10 -0700
Message-ID: <1188990550.187089.121000@o80g2000hse.googlegroups.com>


Hi,

i was reading some paper related on clustering factor, this column aimed to identified if the rows of a table are synchronized (ordered) with the index.
If i don't mistake, the value of clustering_factor have to approached to number of blocks of the table and more far away from number of rows.

So, if i have understood well, main indications on this column are:

  1. if c factor is lower than blocks, maybe the table could have problems of fragmentation because of many DML statements (insert and delete)
  2. if c factor is higher than blocks and it approach to num_rows, then the rows in the index are not ordered (not sync with the index).

In first case: is SHRINK the table a method for resolve the problem? In second case: rebuild index resolve order of the rows ?

Or, for both case the only best method is truncate and reinsert all rows?

thanks for your advice and opinions.
bye

--
Andrea
( a guy that tries to become to DBA)
Received on Wed Sep 05 2007 - 06:09:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US