SQL Server Performance Forum – Threads Archive
IndexHI ALL, Is there any way to disable or enable index on sqlserver table instead of drop/recreate index? Thanks,
I’m afraid no.
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
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
ALTER TABLE MyTable DISABLE TRIGGER MyTrigger
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
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.