Some Good Resources on Database Performance Optimization and Tuning

database symbol

Database performance optimization is a skill that is very important for both the database administrator and the database developer. I decided to put together a few links here that may be useful in disseminating information about database tuning and query optimization on various database systems, both relational and non-relational. I’ll be updating this from time to time as I come across new resources.

Microsoft SQL Server:

Optimizing Databases
SQL Database Performance Tuning for Developers

Oracle Database:

Database SQL Tuning Guide


Tuning Your PostgreSQL Server


How to optimize a MySQL database


Optimization Strategies for MongoDB

database symbol