Click main image to view in full screen. Unlock all 15 preview images:
Complete Guide to DBA Practices & Procedures - Database Performance - Part 11 – PowerPoint PPTX Template
PowerPoint (PPTX) 45 Slides
PPT TEMPLATE 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: Complete Guide to DBA Practices & Procedures - Database Performance - Part 11 PowerPoint (PPTX) Presentation Slide Deck, CSMullins
