Database performance tips

After some years of making programs for all kind of tasks, I would like to share some performance tips, regarding to databases.
Because all those programs have one in common. They all communicate with different databases. Different programs, different programming languages, different kind of tasks, different databases.