dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL
Expertise: Beginner
Dec 21, 2017

Disable Indexes with SQL

Sometimes you will need to disable an index, albeit temporarily. In order to disable an Index, make use of the following T-SQL Query:

USE DatabaseName
GO 
ALTER INDEX NameOfIndex ON Table.Field DISABLE 
GO 


SELECT NAME AS [IndexName], TYPE_DESC AS [IndexType], 
CASE IS_DISABLED  
WHEN 0 THEN 'Enabled' 
ELSE 'Disabled'  
END AS [IndexInfo],  
FILL_FACTOR AS [FillFactor] FROM SYS.INDEXES 
WHERE OBJECT_ID = OBJECT_ID('Table.Field') ORDER BY IndexName, IndexInfo
GO
Hannes du Preez
 
Thanks for your registration, follow us on our social networks to keep up-to-date