-
Hi,
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 shankar_gk@hotmail.com
G.Shankar.
-
Hello
Why recreate the index if you are on 8i try rebuliding the index instead..............as index revuilding is much faster .
regards
hrishy
-
Hi,
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;
Regards,
ROhit Nirkhe,Oracle DBA,OCp 8i
rohitsn@altavista.com
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|