Re: index rebuild

[AK]

The only reason I wanted to build the indexes was to relocate them to another tablespace ( LMT ) so that I can get rid of high fragmentation and start living .   -ak   ----- Original Message ----- From: Tanel Poder To: Multiple recipients of list ORACLE-L Sent: Wednesday, July 23, 2003 11:49 AM 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 To: Multiple 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 .   -ak