Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: When should Index be rebuilt or recreate ?
Assoy,
The simple answer is "when it needs it" :-) but of course the
issue is how
do you know it needs it?
Easiest way is to do a -
ANALYZE INDEX blah validate structure;
and
ANALYZE INDEX blah compute statistics;
then look at the index stats checking for free space, depth of
the tree, number of leaf blocks compares with number
of index values.
If an index is fairly homogeneous it doesn't require much
attention but if based on a constantly growing key it will tend
to get
too wide one direction and then needs rebuilding.
Hope this helps
> Hi,
> Can anyone tell me when should an Index be rebuilt or
Recreate ?
> Thank you for your attention.
>
> Regards
>
> Assoy
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
>
--
This answer is courtesy of QuestionExchange.com
http://www.questionexchange.com/showUsenetGuest.jhtml?ans_id=8227&cus_id=USENET&qtn_id=7360
Received on Mon Dec 13 1999 - 09:42:04 CST