1
Vote

Declares an index as duplicate if same except in filter clause

description

I've got a table that has two filtered indexes that are identical EXCEPT the filter clause. The script declares them DUP and suggests dropping. I've made the modifications to the script to compare the filter clause too.
 
Look for filter_definition occurring in the attached file.

file attachments

comments