| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Rebuild Indexes
I meant "monotonically increasing index that is also being _deleted_" only.
Many thanx to you and Tanel for the explanation.
Regards
Naveen
>-----Original Message-----
>From: John Kanagaraj [mailto:john.kanagaraj_at_hds.com]
>Sent: Wednesday, February 18, 2004 10:30 PM
>To: 'oracle-l_at_freelists.org'
>Subject: RE: Rebuild Indexes
>
>
>Naveen,
>
>I believe the problem is not with a monotonically increasing
>index (which
>should NOT be rebuilt as it is of no use) - rather it is with a
>monotonically increasing index that is also being _deleted.
>This is typical
>of indexes on FIFO-type tables such as the
>FND_CONCURRENT_REQUESTS in Apps
>(any version). In the latter case, you should perform a
>'one-time' index
>rebuild of such monotonically-increasing, followed by regular
>COALESCE of
>the indexes to 'reclaim' 'lost' space. Jonathan/Richard Foote
>might have
>something to add on this....
>
>John Kanagaraj <><
>DB Soft Inc
>Phone: 408-970-7002 (W)
>
>Listen to great, commercial-free christian music 24x7x365 at
>http://www.klove.com
>
>** The opinions and facts contained in this message are
>entirely mine and do
>not reflect those of my employer or customers **
>
>>-----Original Message-----
>>From: oracle-l-bounce_at_freelists.org
>>[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Naveen,
>>Nahata (IE10)
>>Sent: Tuesday, February 17, 2004 11:24 PM
>>To: oracle-l_at_freelists.org
>>Subject: RE: Rebuild Indexes
>>
>>
>>John,
>>
>>Would it be advisable to go for Index rebuilds in case of
>>index based on
>>monotonically increasing columns? As much as I understand (and
>>I must admit,
>>i don't know much about the internals of indexes), in case of
>>such indexes
>>the problem of 'leaf block split' should not happen.
>>
>>Regards
>>Naveen
>>
>>>-----Original Message-----
>>>From: John Kanagaraj [mailto:john.kanagaraj_at_hds.com]
>>>Sent: Wednesday, February 18, 2004 12:30 PM
>>>To: 'oracle-l_at_freelists.org'
>>>Subject: RE: Rebuild Indexes
>>>
>>>
>>>Vidya,
>>>
>>>If you are collecting (and storing) STATSPACK data, you might want to
>>>baseline V$SYSSTAT values and look for spurts in 'leaf node
>>>splits' after
>>>rebuilds....
>>>
>>>John Kanagaraj <><
>>----------------------------------------------------------------
>>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>>----------------------------------------------------------------
>>To unsubscribe send email to: oracle-l-request_at_freelists.org
>>put 'unsubscribe' in the subject line.
>>--
>>Archives are at http://www.freelists.org/archives/oracle-l/
>>FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
>>-----------------------------------------------------------------
>>
>----------------------------------------------------------------
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>----------------------------------------------------------------
>To unsubscribe send email to: oracle-l-request_at_freelists.org
>put 'unsubscribe' in the subject line.
>--
>Archives are at http://www.freelists.org/archives/oracle-l/
>FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
>-----------------------------------------------------------------
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Thu Feb 19 2004 - 01:03:31 CST
 |
 |