
132 Automated Physical Database Design and Tuning
FIGURE 7.7 Additional reports produced by DTA. (Used with permission
from Microsoft.)
and supporting statistics that should be created. For instance, the first item in
the recommendation is an index on table customer over columns c
nationkey
and c
custkey, and the second item is a multicolumn statistic on columns
c
custkey and c acctbal. Selecting any such item produces a preview script
with the Standard Query Language (SQL) statement that can be used to create
the index or statistic in the DBMS.
In addition to the recommended configuration, DTA produces reports that
give information back to the user. Figure ...