RE: index rebuild

AK

    Even though you can rebuild indexes online, it is a good idea to perform this task when the table is being hit with only a light DML load.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----

From: Tanel Poder [mailto:tanel.poder.003_at_mail.ee] Sent: Wednesday, July 23, 2003 1:49 PM
To: Multiple recipients of list ORACLE-L Subject: Re: index rebuild

Hi!  

For index, yes, if you use: alter index <name> rebuild compute statistics;  

But don't rebuild your indexes daily, it's an expensive operation... and you won't gain much from it anyway.  

Tanel.

• Original Message ----- From: AK <mailto:oramagic_at_hotmail.com> To: Multiple <mailto:ORACLE-L_at_fatcity.com> recipients of list ORACLE-L Sent: Wednesday, July 23, 2003 9:14 PM Subject: index rebuild

Does index rebuild generates new statistics as well ? How does that can hit performance intermediately if I want to rebuild few indexes daily just to finish everything in 5 days . Received on Wed Jul 23 2003 - 15:49:04 CDT