Physical database design the database professional's guide to exploiting indexes, views, storage, and more - Lightstone, Sam; Teorey, Toby J.; Nadeau, Tom 1958-. (Amsterdam Boston Morgan Kaufmann/Elsevier, 2007)
1: Introduction to physical database design -- 2: Basic indexing methods -- 3: Query optimization and plan selection -- 4: Selecting indexes -- 5: Selecting materialized views -- 6: Shared nothing partitioning -- 7: Range partitioning -- 8: Multidimensional clustering -- 9: The interdependence problem (i.e. design choices) -- 10: Data sampling in design exploration -- 11: Access plan selection and physical design -- 12: Automated physical database design -- 13: Down to the metal -- 14: Physical design for Decision Support, Warehousing and OLAP -- 15: Denormalization -- 16: Distributed Data Allocation -- Appendix A: A Simple Performance Model for Database.
Keywords: Database design; Electronic books