How to disable an index using select query

hi
murugavel

refer this

http://www.sqlservercentral.com/Forums/Topic981481-338-1.aspx

Mark as Answer if its helpful to you

Kumaraspcode2009@gmail.com

Murugavelmsc, if this helps please login to Mark As Answer. | Alert Moderator

TRY THIS ONE

ALTER INDEX [INDEX_NAME] ON [TABLE_NAME] DISABLE


REGARDS
MANOJ SAHOO

Murugavelmsc, if this helps please login to Mark As Answer. | Alert Moderator

Hi

To disable the index :
ALTER INDEX IndexName ON TableName DISABLE

Thanks & Regards,
Santhi .V

Murugavelmsc, if this helps please login to Mark As Answer. | Alert Moderator

USE AdventureWorks
GO
ALTER INDEX IX_Address_StateProvinceID ON Person.Address DISABLE
GO

-- Query to check Index Usage
SELECT NAME AS [IndexName], TYPE_DESC AS [IndexType],
CASE IS_DISABLED
WHEN 0 THEN 'Enabled'
ELSE 'Disabled'
END AS [IndexUsage],
FILL_FACTOR AS [FillFactor] FROM SYS.INDEXES
WHERE OBJECT_ID = OBJECT_ID('Person.Address') ORDER BY IndexName, IndexUsage
GO

Life is a Race
Thanks & Regards
By
Sabari Mahesh P M

Murugavelmsc, if this helps please login to Mark As Answer. | Alert Moderator