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:
PostgreSQL:
MySQL:
How to optimize a MySQL database
MongoDB:
Optimization Strategies for MongoDB