VA Indexing Command Center
Score < 5k: Healthy
Score 5k-50k: Warning
Score 50k+: Critical Gap
DBA Tips: Surgical Strategy
- Order of Operations: Place Blue (Equality) columns before Pink (Inequality) columns to turn a 'Scan' into a 'Seek.'
- Covering Index: Use Green (Included) columns to stop expensive Key Lookups and reduce physical I/O.
- High Availability: The T-SQL FIX uses
ONLINE = ONto ensure Veteran services aren't disrupted during tuning.
Critical Gaps
0
Avg Benefit
38.1 %
Total Missing
3
Top Table
Veterans
| Status | Score | Benefit | Table | Equality | Inequality | Included | T-SQL FIX |
|---|---|---|---|---|---|---|---|
| WARNING | 9630 | 74.76% | Veterans | [VetID] |
|
[LastName] |
CREATE NONCLUSTERED INDEX [IX_Veterans_5] ON [AWL].[dbo].[Veterans] ([VetID]) INCLUDE ([LastName]) WITH (ONLINE = ON); |
| OK | 3208 | 24.91% | MedicalRecords | [DiagnosisCode] |
[RecordDate] |
[VetID] |
CREATE NONCLUSTERED INDEX [IX_MedicalRecords_7] ON [AWL].[dbo].[MedicalRecords] ([DiagnosisCode],[RecordDate]) INCLUDE ([VetID]) WITH (ONLINE = ON); |
| OK | 38 | 14.70% | Appointments | [ApptStatus] |
|
[VetID], [ApptDate] |
CREATE NONCLUSTERED INDEX [IX_Appointments_2] ON [AWL].[dbo].[Appointments] ([ApptStatus]) INCLUDE ([VetID], [ApptDate]) WITH (ONLINE = ON); |
Reference: Raw Truth Verification Query
SELECT * FROM sys.dm_db_missing_index_group_stats gs INNER JOIN sys.dm_db_missing_index_groups ig ON gs.group_handle = ig.index_group_handle INNER JOIN sys.dm_db_missing_index_details id ON ig.index_handle = id.index_handle;