
Practical Aspects in Physical Database Design 127
Sample Report Description
Query frequency Lists all queries in the workload sorted by fre-
quency of occurrence
Current query cost Lists all queries in the workload sorted by es-
timated cost under the current configuration
Recommended query cost Lists all queries in the workload sorted by es-
timated cost under the recommended configu-
ration
Current indexes Lists information about each index in the cur-
rent configuration, the fraction of queries in
the workload that use the index, and the dif-
ferent ways the index is used in the workload
Recommended indexes Same as current indexes but with respect to
the ...