-
Index problem
I tried adding a new index to a table today and got the following error message.
Error: Message 1910 cannot create more then 249 non-clustered indexes or column stats on one table.
I never had this before and I am not sure how to clear it so I can add an index I need for performance.
-
That means table has 249 indices and column statistics already, drop some unused ones first.
-
the table only has 3 indexes on it. any ideas?
-
Then check how many statistics it has.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|