BryanMorrow

Script to list all the indexes in the Nimsoft Database

Discussion created by BryanMorrow on Oct 29, 2010

With the recent issues surrounding the data_engine performance and different versions of NMS having different indexes someone in support created a script to retrieve the index information. This is not my creation but it might save you some time in getting information to support in regards to slow data_engine performance.

 

 

USE NimsoftSLM GO   SELECT        so.name AS TableName       , si.name AS IndexName       , si.type_desc AS IndexType FROM        sys.indexes si        JOIN sys.objects so ON si.[object_id] = so.[object_id] WHERE        so.type = 'U'     --Only get indexes for User Created Tables       AND si.name IS NOT NULL ORDER BY        so.name, si.type 

Outcomes