When sp_BlitzIndex does index suggestions, the question in my head is as below:
Yes the suggested index would bring a lot of speed benefit when doing select statements. But there are also another costs for these indexes which are delete, insert, update queries
Do sp_BlitzIndex script take into consideration delete, insert, update costs as well? or only it does evaluate how much speed benefit would come with select statements?
Moreover, how can i list bad indexes via sp_BlitzIndex? and how are they determined to be bad?
Thank you very much for answers