Re: rebuild or not rebuild index file, when ?, how?

Hi,

Also, it's good to rebuild if your index has a high percentage of deletions..depending on what book you read the percentage varies but I recall seeing 10% and 20%.

To rebuild (the index in this example is s_dept_id_pk), use

SQL> alter index s_dept_id_pk rebuild;

Index altered.

Steve

David Busby wrote:

> Every so often you should check the height of your indexes and see if
> the need rebuilding. If your not having a performance problem than I
> would probably not do anything. But if you need more I will give you
> a script to check the index(es) and tell which ones and how to rebuild
> them.
>
> PIERRE HIRTH wrote:
>
>> Hi,
>>
>> With an Oracle DataBase is it necessary to rebuild files index from
>> time to
>> time and how ?
>>
>> Thank you
>
Received on Wed Apr 11 2001 - 06:56:21 CDT