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