It actually checks all custom indexes and compares the columns and include columns to ensure that they do not exist in other indexes.  As far as over-indexing goes that is merely something to monitor.  If necessary I also have a script that removes all of the customized indexes and allows it to rebuild the necessary indexing again from scratch.  This is the reason why I recommend running the job adhoc in larger databases.