3 ms·
Also StrataScratch.com for leetcode for SQL. What really distinguishes an SQL master is working with queries hundreds of lines long, and query optimization. Fo
by carabiner 3y ago
Also StrataScratch.com for leetcode for SQL.
What really distinguishes an SQL master is working with queries hundreds of lines long, and query optimization. For example, you can often make queries faster by taking out joins and replacing them with window functions. It's hard to practice these techniques outside of a legit enterprise dataset with billions of rows (maybe a good startup idea).
- swasheck 3y agoone of the most performance-killing practices i’ve seen (outside of brutal orm-generated queries) is the sql hero who wants to do everything all at once in a single splat of sql. at a certain level of complexity, breaking things up into logical units and even forcing materialization (instead of hoping for some good intermediate materialization) can go a long way
- deleted 3y ago[deleted]