When I deleting records, It will take nearly one hours and recreating index will take more than 8hours.
The table 'ORDER' size is 1.2GB
What is the problem for recreating Index?
Maile me ,
my email id is firstname.lastname@example.org
Why recreate the index if you are on 8i try rebuliding the index instead..............as index revuilding is much faster .
Its better to rebuild the current index rather than dropping and recreating it.In Oracle 8i there is an option of rebuilding the index online when u are performing DML statements on the table.
So its better to rebuild the index in the less office peak times(usally in the night) which will be faster.
Command to rebuild the index online
alter index scott.empno_index rebuild online;
ROhit Nirkhe,Oracle DBA,OCp 8i
Click Here to Expand Forum to Full Width