If you have the time and it won't affect the users ... drop and recreate
the indexes and regenerate statistics.

If you cancel using rebuild the original index will still be there.


-----Original Message-----
From: Shamsuri_Chik
[mailto:oracledba-ezmlmshield-x20139497.[Email address protected]
Sent: Friday, July 28, 2006 4:33 AM
To: LazyDBA Discussion
Subject: In Middle Of Rebuilding Index



Hi Gurus,

I have tables with 10mil of records. I wish to rebuild the indexes for
these tables. What do I do? Do I REBUILD the indexes or DROP and
CREATE the indexes? Which one performs better for tables with millions
of records? I am not too sure. And what would happen to the original
index if I cancel the REBUILD statement? Will it still be there or
dissappeared and need to recreate?

Your inputs are much appreciated. Thank you.


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page