3 ms·
Knowing how to optimise SQL (and also database indexes) is a valuable skill. Reducing a highly used query's execution time by several orders of magnitude can b
by dwd 8y ago
Knowing how to optimise SQL (and also database indexes) is a valuable skill.
Reducing a highly used query's execution time by several orders of magnitude can be quite gratifying.
- faceplanted 8y agoStick the --+ORDERED flag on a random select sometime and look at what happens to the estimated query cost to see how easy it would be to fuck this up if you had to make all the optimisation choices yourself.