November 26, 2008 at 10:14 am
is thier anyway in sql 7.0 to identify which indexes should be dropped, one of my table have 11 indexes, and I am having issues while inserting and updating records in that table.
thank you
November 26, 2008 at 10:37 am
(Repeating post from http://www.sqlservercentral.com/Forums/FindPost609293.aspx)
Run all queries that affect that table with the execution plan option enabled. See which indexes they are using. Remove any that aren't used by any query. make sure you account for seldom-run queries, like month-end or year-end reports.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply