Welcome to the DBmarlin Knowledge-base which is a collection of curated knowledge around database performance spanning multiple database types.
This online resource is provided for FREE to anyone to learn from. If you would like to contribute your own knowledge please email firstname.lastname@example.org or suggest an edit using the forms provided.
The knowledge sections below start with 2 of the most important things you should know in order to better understand database performance. These are topics which many struggle with. That is wait events which tell you where the time in the database is spent and execution plans which help you understand the steps that the database optimiser is going to perform in order to execute a SQL statement. By better understanding these 2 subjects, you can remove some of the mystery surrounding database performance tuning and optimisation.