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.