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 -> Re: index CLUSTERING_FACTOR can be reduce

Re: index CLUSTERING_FACTOR can be reduce

From: Mladen Gogala <mgogala.SPAM-ME.NOT_at_verizon.net>
Date: Wed, 18 Apr 2007 21:24:01 +0200 (CEST)
Message-ID: <pan.2007.04.18.19.20.07@verizon.net> 





On Mon, 16 Apr 2007 00:50:05 -0700, peter wrote:



> is there any way to reduce CLUSTERING_FACTOR of any index.




Rebuild the table or use DBMS_STATS.SET_INDEX_STATS


-- 
http://www.mladen-gogala.com


Received on Wed Apr 18 2007 - 14:24:01 CDT












Original text of this message













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