Beyond that effort in automatic physical design, Oracle’s SQL
Tuning advisor [18] can collect statistics, correct system
parameters, and recommend changes to SQL statements. (In the
running example of this paper, the Tuning Advisor found high
load SQL statements and identified bad query features like
Cartesian products.) Such tools work at the SQL statement level,