December 8, 2006 at 4:37 am
Dear All,
I have one table. that table contains 3200000 Records.
I am creating one index on it. The index creation takes lot's of time.
Is there another way that will take less time for index creation.
Thannks in advance.
December 8, 2006 at 7:16 am
Assuming you can't live without the index, you'll have to wait while it creates itself. Maybe you can wait to create it off hours when the server is less busy. But unfortunately I don't know any ways of speeding this up!
December 11, 2006 at 9:53 am
how long is lots of time?
i've seen indexes take hours to create on large tables
December 11, 2006 at 11:12 am
How many rows and what is the pysical size of the table...Are you creating clustered/non-clustered index?
You posted this in SQL 2005 forum, I think you are using sql 2005... If you are in EE then you use online indexing option...
To speed up you... if your tempdb on a different drive you make use of Sort in tempdb option...
MohammedU
Microsoft SQL Server MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply