2 ms·
Other than The Fine Manual, linked by a sibling comment, not really. Everything I've learned, I've just picked up along the way. EDIT: When I wanted to learn a
by rosser 12y ago
Other than The Fine Manual, linked by a sibling comment, not really. Everything I've learned, I've just picked up along the way.
EDIT: When I wanted to learn about CTEs, for example, I conveniently had a large, ugly materialized view that needed refactoring, and they happened to fit the need perfectly. The previous version was, in places, five or six layers of subqueries deep, many of them repeated several times as they were reused. It hurt to read. Rewriting it to use CTEs made it about eight times faster, and the SQL script was a third the size of the original.