BTW -
It's not an IOT table is it? (I hope not for your sake!)

-----Original Message-----
I'm temporarily stuck with a bad db design and index usage so I am having
TERRIBLE performance and completion time for a stored procedure which does
massive updates on an indexed column. Does anyone have any tuning tips as
to sort_area_size or anything else they could give me. Any good
documentation on what happens when and indexed column is updated would be
greatly appreciated.

TIA

Jim




**********************************************************
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