The Complete Guide to DBA Practices & Procedures - Database Performance - Part 11 (PowerPoint PPTX)

DESCRIPTION

This product (The Complete Guide to DBA Practices & Procedures - Database Performance - Part 11) is a 45-slide PPT PowerPoint presentation (PPTX), which you can download immediately upon purchase.

Part 11 of a multi-part series of presentations on the management discipline of database administration. This installment extends the coverage of managing database performance to look at the details of tuning and optimizing the database itself. The entire series can be used to implement an efficient and effective database administration function at your organization. This part covers the following areas:
•  Techniques for Optimizing Databases
— Partitioning
— Raw Partitions
— Indexing
— Denormalization
— Clustering
— Interleaving Data
— Free Space
— Compression
— File placement and allocation
— Page size (Block size)
•  Database Reorganization

Source: The Complete Guide to DBA Practices & Procedures - Database Performance - Part 11 PowerPoint (PPTX) Presentation, CSMullins