Timeline for NonClustered Index not being Used
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 6, 2018 at 15:10 | comment | added | sepupic | You can set statistics io on and add a hint with(index(IX_TestIndexSample_Name)) to your selects and see how many pages are red | |
| Mar 6, 2018 at 15:09 | comment | added | sepupic | index_id = 3 is your nonclustered index. id=3 just means that there was another nonclustered with id=2 but it was dropped | |
| Mar 6, 2018 at 15:01 | comment | added | Kevin | I get 6 total pages for Index_id 1; 5 total pages for Index_id 3. Don't see Index_id 2 | |
| Mar 6, 2018 at 14:56 | history | answered | sepupic | CC BY-SA 3.0 |