Skip to Main Content
Automated Physical Database Design and Tuning
book

Automated Physical Database Design and Tuning

by Nicolas Bruno
February 2011
Intermediate to advanced content levelIntermediate to advanced
253 pages
8h 4m
English
CRC Press
Content preview from Automated Physical Database Design and Tuning
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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

What Is Database Design, Anyway?

What Is Database Design, Anyway?

C.J. Date
Physical Database Design

Physical Database Design

Sam S. Lightstone, Toby J. Teorey, Tom Nadeau

Publisher Resources

ISBN: 9781439815670