What resources exist for Database performance-tuning?

mysql sql-server database oracle postgresql
Gavin Miller picture Gavin Miller · Apr 17, 2009 · Viewed 14.9k times · Source

What good resources exist for understanding database tuning on the major engines and advancing your knowledge in that area?

The idea of this question is to collect the shed load of resources that invariably exist, so that people can have a "one stop" knowledge shop of the good, peer approved resources.

General SQL

PostgreSQL (wiki) (PGsearch)

MySQL

Oracle

MS SQL Server

Sybase SQL Anywhere

JDBC

Answer

Neil Kodner picture Neil Kodner · Apr 24, 2009

Oracle's very own Tom Kyte has a fantastic repository on every type of performance problem imaginable on http://asktom.oracle.com. He usually takes the time to recreate specific problems and gives very detailed explanations.

Related questions

How do I list all the columns in a table?

For the various popular database systems, how do you list all the columns in a table?

Read More
Storing JSON in database vs. having a new column for each key

I am implementing the following model for storing user related data in my table - I have 2 columns - uid (primary key) and a meta column which stores other data about the user in JSON format. uid | meta -------------------------------------------------- 1 | {name:[…

Read More
Differences between Database and Schema using different databases?

What are the differences in database terminology between MS SQL and MySQL? Can a MySQL instance have more than one database? It appears that it can only create different schemas. However, the SQL command is create database. In MS SQL, …

Read More