By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,610 Members | 2,332 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,610 IT Pros & Developers. It's quick & easy.

How to create an index fast?

P: 2

I have a table with close to 30 lakh records. Now I wish to create an index on one of the columns.

Earlier when I had tried to create an index on another column on the same table, the query ran for more than 24 hours.

I cannot afford to give that much down time. Could you tell me a way to create this index at a faster speed?


Dec 14 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.