Index creation [message #471719] |
Tue, 17 August 2010 00:27 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
prashant_ora
Messages: 196 Registered: July 2010
|
Senior Member |
|
|
Is there any way to reduce the index creation time. I have one table which has 7700000 records and every day this table get truncate and we create with create table as select statement and then create the 4 indexes and each index took 5 minutes so in totality it took 20 minutes in index creation. So pl advice.
|
|
|
|
Re: Index creation [message #471725 is a reply to message #471720] |
Tue, 17 August 2010 01:09 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68678 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote:So pl advice.
Same advices than in your N previous topics where you talk about the same issue.
Do you think than repeating the same question will lead to a different answer?
Regards
Michel
[Updated on: Tue, 17 August 2010 01:10] Report message to a moderator
|
|
|