DESCRIPTION
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
Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.
Source: The Complete Guide to DBA Practices & Procedures - Database Performance - Part 11 PowerPoint (PPTX) Presentation, CSMullins
Download our FREE Strategy & Transformation Framework Templates
Download our free compilation of 50+ Strategy & Transformation slides and templates. Frameworks include McKinsey 7-S Strategy Model, Balanced Scorecard, Disruptive Innovation, BCG Experience Curve, and many more. |