Index | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Index

HI ALL, Is there any way to disable or enable index on sqlserver table instead of drop/recreate index? Thanks,
Sriram.
I’m afraid no.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.
Thanks.We can disable and enable indexes on some Database server tables i.e INFORMIX IDS
Interesting. What does that actually mean? I guess when disabled they are not used to accomodate selects, but does data modifications modify disabled index?
Indexes are separate entities from the table, and disabling is only possible for parts that are part of the table design, like constraints:
ALTER TABLE MyTable NOCHECK CONSTRAINT MyConstraint
and triggers:
ALTER TABLE MyTable DISABLE TRIGGER MyTrigger
or even:
ALTER TABLE MyTable DISABLE TRIGGER ALL

In layman terms, Indexes are like limbs for tables and you can cannot disable them to workout [8D]. Other thank dropping and recreating this facility is not available in SQL, may be availabel in other applications. HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>