Database Reference
In-Depth Information
> # compare this configuration with the base one for all queries in the workload
> Compare-Configurations -Workload $w -Config1 $bestC -Config2 (Get-Configuration base)
280
Myc
Base
240
200
160
120
80
40
0
> # 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
tpch1g
2454.9765625
1080.27443
27
> # show all configurations evaluated by Refine-Configuration graphically
> dir P:/tpch1g/configurations | out-chart -values size -xvalues cost -gallery scatter
3600
3200
2800
2400
2000
1600
1200
800
400
0
0
300
600
900
1200
1500
1800
2100
2400
FIGURE 12.4
(Continued).
Search WWH ::




Custom Search