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
154 Automated Physical Database Design and Tuning
instances. We next discuss an approach to limit the set of views to consider
in bottom-up enumeration strategies.
8.4.1 Restricting the Enumeration Space
An observation that motivates the following approach is that certain subsets
of tables are not particularly helpful to consider. Specifically, even if we were
to propose materialized views on those table subsets, the resulting configu-
ration would be only slightly more efficient. This can happen because the
table subsets occur either infrequently in the workload or only in inexpensive
queries. For instance, consider a workload of 100 queries whose total ...
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