Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Never rebuild Indexes?
DA Morgan wrote:
> Oradba Linux wrote:
>> 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.