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
Last activity: Oct 4, 2021, 03:02 PM