My question is this:
sp_blitzindex, I get a lot of these 2 warnings/suggestions:
Index Hoarder: Unused NC index
Feature-Phobic Indexes: Potential filtered index (based on column name)
With index hoarder, these are indexes that I've built against a FK column. I thought somewhere I read that was a good idea to have.
With feature-phobic, I had indexes set up to use these cols (where clause in the index definition), but when using
sp_blitzindex, I got a lot of recommendations for indexes that didn't use the feature. (It either stuck the bit field in the includes or in the index itself.)
What are your thoughts on whether or not to keep the indexes on the FKs? And, where do you think I could get the most bang for indexes (features or results of your blitzindex?)
Right now this is being used against an OLTP system that has some flat tables used for searching.