
New Challenges in Physical Database Design 227
> # compare this configuration with the base one for all queries in the workload
> Compare-Configurations -Workload $w -Config1 $bestC -Config2 (Get-Configuration base)
240
280
200
160
120
80
40
0
Myc Base
Q0
Q1
Q2
Q3
Q4
Q5
Q6
Q7
Q8
Q9
Q10
Q11
Q12
Q13
Q14
Q15
Q16
Q17
Q18
Q19
Q20
Q21
> # bestC surely is better, but what is its size compared to that of base?
> $bestC.size, (Get-Configuration base).size
3535.44, 1234.52
> # bestC is 2.9 times larger than base, refine it down to 2.5GB
> $refC = Refine-Configuration -Configuration $bestC -Size 2500 -Workload $w -Timeout 20
Name Database Size Cost Indexes
---- -------- ---- ---- -------
C11 ...