alternative to drop and recreate index
spur230Apr 16 2012 — edited Apr 16 2012Hi All,
We are using Oracle 11.2.0.2. We have a script where we are dropping indexes prior to full update of a table and recreating index to improve performance.
Rather than dropping and recreating indexes, I wanted to know if there are any other better approach to achieve performance gain.
I was thinking of making index unusable and rebuilding it later. Would it be better option to drop and recreate index.
Thanks for your time.