≡ Menu
Deep in the Code

Some Good Resources on Database Performance Optimization and Tuning

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

PostgreSQL:

Tuning Your PostgreSQL Server

MySQL:

How to optimize a MySQL database

MongoDB:

Optimization Strategies for MongoDB

database symbol

About the author: I solve problems. Solutions Architect / Senior Software Engineer / Business Analyst / Full-Stack Developer / IT Generalist