The Query Advisor uses a set of rules and best-practices to find structures in a query that are likely cause the optimizer to choose a suboptimal access path. You can rewrite the query to resolve the problems that are identified in the recommendations.
You can choose to hide any type of recommendation issued by the Query Advisor. Recommendations based on the same rule are not shown again for new SQL statements within the scope that you specify in the preferences.