If you're going to capture a trace of your workload, you might want to try DBSophic's Qure Optimizer. It can recommend indexes, SQL rewrite and schema changes - depending on your database and workload, of course.

However, you should be aware that Qure Optimizer needs to run against a copy of the production database, so it requires more setup than just running DTA against your database.