disable index

Question

disable index

abhisek karki

SSCrazy

Points: 2518
More actions
November 26, 2008 at 9:52 am

#72305

is thier anyway we can disable index in sql server 7.0

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Prior to SQL 2005, the only way is to drop the index.

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

abhisek karki SSCrazy Points: 2518 More actions · Answer 2

thanks for the information, 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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

abhisek karki SSCrazy Points: 2518 More actions · Answer 4

thanks for the information, can you expain me in some detail how do i run the query with execution plan enabled.

thank you

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

I'm not familiar with SQL 7. In SQL 2000's query analyser there was a button on the toolbar. If it's not ther, try SET SHOWPLAN_ALL ON, though that's a lot harder to interpret.

I'd suggest you take a look a the docs for SQL 7.

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 6

Thread continues here: http://www.sqlservercentral.com/Forums/Topic609292-5-1.aspx

In the interests of keeping things together, no more replies to this thread please.

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass