PGCon2013 - Final Release
PGCon 2013
The PostgreSQL Conference
Speakers | |
---|---|
Susanne Ebrecht |
Schedule | |
---|---|
Day | Talks - Day 2 - 2013-05-24 |
Room | MNT 202 |
Start time | 15:00 |
Duration | 01:00 |
Info | |
ID | 561 |
Event type | Lecture |
Track | Applications |
Language used for presentation | English |
SQL hints, tips, tricks and tuning
Performance tips and tricks on SQL level.
What is the difference between inner, outer, cross and natural join? What is a correlated subselect? What is the advantage and what the disadvantage of an index. Is NOT and OR evil? When do I need normalisation and when denormalisation? All this questions and lots of other performance tips and tricks on SQL level will be given in the talk.