Re: CREATE INDEX is very slow
Posted by:
Sal Young
Date: June 20, 2005 12:38PM
I did DROP the index and it took 00:19:47.65 minutes. Then I did shut down the server, defragmented my hard drive, re-started the server and recreated the index which took 00:21:09.06 minutes. This process took most of the memory on the machine which at the starting point there were 370MB available and during peak times only 8MB were available.
My next step is to remove the PRIMARY KEY, and DROP all indexes. Then I'll recreate the single INDEX to see if this approach makes a difference.
Subject
Views
Written By
Posted
4932
June 17, 2005 01:58PM
3594
June 17, 2005 02:17PM
3631
June 20, 2005 07:51AM
3435
June 20, 2005 07:57AM
3516
June 20, 2005 08:19AM
Re: CREATE INDEX is very slow
10480
June 20, 2005 12:38PM
4226
June 20, 2005 04:22PM
3970
June 20, 2005 12:23PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.