Just took a quick look at the code, how does it ensure it isn't "duplicating" indexes that already exist? Remember, a duplicate index doesn't necessarily mean one that has identical columns in identical order. Using the DISTINCT may ensure that you don't create duplicate indexes based on the DMV's but I don't see anything that validates those against existing indexes. The missing index DMV's will show you an index that will satisfy a specific query.