"F. Ugurtan Erdem" wrote:

>
> Before starting to add multible records set your indexes inactive;
>
> ALTER INDEX name INACTIVE;
>
> then when finished set your indexes active
>
> ALTER INDEX name ACTIVE;
>

Im guessing there is an optimum in this - eg in a table with 7 million
records where rebuilding an index takes time and tends to cause the
server a certain amount of hassle the gain for the person
adding/deleting a chunk of records has to be compared to the loss for
all other users?

yours,
Ian