O'Reilly logo

Database Administration: The Complete Guide to DBA Practices and Procedures, Second Edition by Craig S. Mullins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required