July 30, 2008 at 1:45 pm
Hi i have a table with Total Rows = 10,83,581
i am trying to create a clustered index on L_ID which has 10,77,121 distinct values (I know its a bad cluster index).
Now the problem is sql server is giving me time out error. I have checked the tools-->Options-->Query Execution-->Execution Time Out and its already set to 0.
I have also checked the Remote Query time out in Server properties, its also set to 0.
So any thoughts?
Thanks,
usman
July 30, 2008 at 3:49 pm
Are you trying to create this from the designer, or from a query window. If from the designer - yes, you will get a timeout.
To avoid the timeout - issue the CREATE INDEX statement directly in a query window and it will run until it completes.
NOTE: your table will not be available while the index is being built. If you are running Enterprise Edition, you can try building the clustered index online. Lookup CREATE INDEX in BOL for further information and options - especially options like ONLINE=ON and SORT_IN_TEMPDB=ON.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply