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

Home -> Community -> Usenet -> c.d.o.misc -> Never rebuild Indexes?

Never rebuild Indexes?

From: Oradba Linux <oradba_linux_at_verizon.net>
Date: Sun, 04 Feb 2007 03:53:28 GMT
Message-ID: <YMcxh.18401$h75.1713@trnddc01> 





We are running a 4 node RAC on RHEL 3.0. We have a table with 300mil 
rows that has an pk index upto 12Gb and we rebuilt it it came down to 
6g. The data into this table was loaded with concurrent inserts from 
different sessions. This table is on ASSM tablespace. Same thing with 
many other indexes.
Received on Sat Feb 03 2007 - 21:53:28 CST












Original text of this message













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