Question
Indexes on Databases
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);

