Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Never rebuild Indexes?
Oradba Linux schreef:
> 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.
Just wait a couple of weeks...
-- Regards, Frank van Bortel Top-posting is one way to shut me up...Received on Sun Feb 04 2007 - 06:13:28 CST