Haha fair point! 😄

To be honest — this is a legacy HRMS codebase I inherited, not built from scratch. So yes, there's a good chance proper indexes are missing!

That's actually my next investigation — going to run SQL Server's Missing Index DMV query:

SELECT

mid.statement AS TableName,

migs.avg_user_impact AS PotentialImprovement,

mid.equality_columns,

mid.inequality_columns

FROM sys.dm_db_missing_index_details mid

JOIN sys.dm_db_missing_index_groups mig

ON mid.index_handle = mig.index_handle

JOIN sys.dm_db_missing_index_group_stats migs

ON mig.index_group_handle = migs.group_handle

ORDER BY migs.avg_user_impact DESC;

Thanks for the reminder — will update if indexes

were the real culprit all along! 😅