Sample Header Ad - 728x90

Index usage Brent Ozar script

3 votes
1 answer
869 views
I'm using sp_blitzIndex to check the health of my database indexation, but I don't understand every column used in the output. I'm talking specifically about "Usage Stats" and "Op Stats". I find many indexes with zero Reads but a thousand writes (example: Reads: 0 Writes: 42,597). Does it mean that the index isn't used at all ? At least not for SELECT statements ? Is it safe to remove it or disable it at first ? PS: My SQL instance hasn't been rebooted for very long time.
Asked by dba_maroc (31 rep)
Oct 4, 2021, 02:37 PM
Last activity: Oct 4, 2021, 03:02 PM