Optimized Core Shift Retrieval Engines

Situation

Core staff scheduling stored procedures were running at 1,500ms+ per call, impacting the responsiveness of the scheduling solution used across 2,500+ clinics. Under peak load the latency compounded across concurrent sessions.

What I Did

Profiled the execution plans for the highest-frequency scheduling procedures and identified high-churn temporary tables that were missing usable indexes. Engineered targeted nonclustered indexes on those tables to bring set-based operations back into optimal access paths.

Result

Tools & Tech