You can choose to include query revision recommendations as a tuning option when running
the Tuning Wizard. This uses a set of rules and best-practices to find structures in a SQL statement
(or workload) that are likely to cause the optimizer to choose a suboptimal access path(s). Based on
the recommendations, you can rewrite the query to resolve any detected problems.