Skip to main content
19-Tanzanite
May 1, 2026
Question

Indexes on Databases

  • May 1, 2026
  • 1 reply
  • 13 views

Trying to look at ways to improve the speed of Windchill.  I ran the following SQL to find possible areas for improvement.  How many of you build new indexes inside of Windchill?  It looks like WorkItem would benefit a lot.  We do a ton of Change Notices and Change Tasks.

SELECT 
migs.avg_total_user_cost * migs.avg_user_impact AS improvement_measure,
mid.statement AS table_name,
mid.equality_columns,
mid.inequality_columns,
mid.included_columns
FROM sys.dm_db_missing_index_groups mig
JOIN sys.dm_db_missing_index_group_stats migs
ON mig.index_group_handle = migs.group_handle
JOIN sys.dm_db_missing_index_details mid
ON mig.index_handle = mid.index_handle
ORDER BY improvement_measure DESC;

Maybe something like this?

CREATE NONCLUSTERED INDEX IX_WorkItem_Main
ON WorkItem (idA3C4, status)
INCLUDE (idA3A2ownership, createStampA2, modifyStampA2, updateStampA2);

 

1 reply

24-Ruby III
May 1, 2026

Take a look about performance improvement also here: