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 -> Re: Never rebuild Indexes?

Re: Never rebuild Indexes?

From: Oradba Linux <oradba_linux_at_verizon.net>
Date: Sun, 04 Feb 2007 20:11:19 GMT
Message-ID: <H5rxh.382$384.216@trnddc05>


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.

>
> Given it is a RAC cluster I must ask ...
> What type of index?

B*Tree
> Does the primary key include the instance identifier?
No
> What performance metric indicates the rebuild is accomplishing anything?
None. Received on Sun Feb 04 2007 - 14:11:19 CST

Original text of this message

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