> [1] This is database 101 stuff - a class I never took.
Yes, yes, a thousand times yes.
The best and most important way to improve database performance is to have a sensible schema. Query planners can do magic with stuff that's sensibly normalised and with things that are sensibly denormalised.
Where they choke is on schemata where everything is just squished into a bunch of tables with fields holding internal datastructures.
Comments
> [1] This is database 101 stuff - a class I never took.
Yes, yes, a thousand times yes.
The best and most important way to improve database performance is to have a sensible schema. Query planners can do magic with stuff that's sensibly normalised and with things that are sensibly denormalised.
Where they choke is on schemata where everything is just squished into a bunch of tables with fields holding internal datastructures.