I am creating an index on a table wit 35 million records but I get the error
'TT_ObjPerformance' table
- Unable to create index 'IX_TT_ObjPerformance_CACode'.
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
How can I get the index created?
Thanks
SQL Server newbie
From where are you creating the index? via query analyzer/job/some front end( hopefully not)?
No comments:
Post a Comment