Re: index rebuild

[Tanel Poder]

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