Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> estimated of CLUSTERING_FACTOR
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:
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
![]() |
![]() |