Most popular articles in Gints Plivna blog

Natural joins are evil.
ANSI SQL Natural join syntax hides quite big potential problems although it seems very simple and elegant on the first sight.
This article explains them and describes why it is better to avoid natural joins at all.

Where bad performance starts.
A small article about the art of requirements gathering. One of the main reasons for
bad perfomance simply are bad requirements. Also contains a comprehensive list of pointers to articles about
b-tree and bitmap indexes by Cary Millsap, Jonathan Lewis, Brian Hengen, Julian Dyke, Tim Gorman, and Richard Foote.

Copyright notice:
These papers and notes are provided as-is and without warranty. It is your liability to use or not to use them.
You may freely use every paper and note this page contains both for commercial and non-commercial purposes.
You may even make derivative works.
The only requirement is to preseve original author and site.
In legal terms all that is explained here:
This work is licensed under a Creative Commons Attribution-ShareAlike 2.5 License.