Skip to Main Content
Database Administration: The Complete Guide to DBA Practices and Procedures, Second Edition
book

Database Administration: The Complete Guide to DBA Practices and Procedures, Second Edition

by Craig S. Mullins
October 2012
Intermediate to advanced content levelIntermediate to advanced
936 pages
23h 23m
English
Addison-Wesley Professional
Content preview from Database Administration: The Complete Guide to DBA Practices and Procedures, Second Edition

11. Database Performance

Database performance focuses on tuning and optimizing the design, parameters, and physical construction of database objects, specifically tables and indexes, and the files in which their data is stored. The actual composition and structure of database objects must be monitored continually and changed accordingly if the database becomes inefficient. No amount of SQL tweaking or system tuning can optimize the performance of queries run against a poorly designed or disorganized database.

No amount of SQL tweaking or system tuning can optimize the performance of queries run against a poorly designed database.

Techniques for Optimizing Databases

The DBA must be cognizant of the features of the DBMS in order to apply the proper ...

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

Database Administration: The Complete Guide to Practices and Procedures

Database Administration: The Complete Guide to Practices and Procedures

Craig S. Mullins

Publisher Resources

ISBN: 9780133012743Purchase book