• 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.