| Index creation [message #471719] |
Tue, 17 August 2010 00:27  |
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  |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
