Ow!

Anyway you may look at dropping the index, doing updates , then adding it
back if you update a *LOT* of rows. You are in a sense rebuilding the index
anway.

Also look at bulk updates in pl/sql.

And as always 'You can never have too much money or too much memory'

G'luck





**********************************************************
DISCLAIMER: This email and any files transmitted with it are confidential
and intended solely for the use of the individual or entity to whom they are
addressed. If you have received this email in error please notify the sender
by replying to this message and then delete it from your system. Use,
dissemination or copying of this message by unintended recipients is not
authorized and may be unlawful. Please note that any views or opinions
presented in this email are solely those of the author and do not
necessarily represent those of the company. Finally, the recipient should
check this email and any attachments for the presence of viruses. The
company accepts no liability for any damage caused by any virus transmitted
by this email.





Oracle LazyDBA home page