• I would not automate this. Each index suggested needs to looked at with a critical eye, not just at the individual index but at al the other indexes suggested on the same table and already on the table.

    I have gone through this process myself, and yes it is time consuming but in the end you will have a better set of recommendations to provide regarding what indexes should exist on each table.