4 ms·

Since you ased about indexing in particular, here is my site about indexing: https://use-the-index-luke.com/ https://use-the-index-luke.com/ You might also wa

Since you ased about indexing in particular, here is my site about indexing: https://use-the-index-luke.com/ https://use-the-index-luke.com/ You might also want to follow my other project: https://modern-sql.com/ https://modern-sql.com/

alexpetralia 8y ago
One more vote for use-the-index-Luke. Clear, concise and comprehensive - I used this quite a bit when studying for interviews or optimizing database performance. Great resource!
- frosted-flakes 8y ago
  His book (SQL Performance Explained) is also very good. The book is not too long and not too dense. I'd buy it again (in fact, I probably will, because I left my copy with a former employer because they paid for it).
wenc 8y ago
I was introduced to Markus' work by way of Wes McKinney's Twitter link [1]. This is deeper SQL-fu that many of us typically encounter. Highly recommend. [1] https://twitter.com/wesmckinn/status/564526251591733248 https://twitter.com/wesmckinn/status/564526251591733248
miluge 8y ago
I used your website to relearn SQL for work! I can't thank you enough for it and getting promoted.
tmm84 8y ago
I love use the index luke. Some of the best query advice I can get when I have to get something done faster. Personally, the most important part of getting advanced with SQL is being able to vizualize the DB in your mind and how the query should look. Also, sometimes bad design is at fault than a query. If the design is too complicated or wrong a query is gonna be slow in relation to the amount of data it has to go over.
kakwa_ 8y ago
It's a bit off topic since it's not a resource for learning, but: http://tatiyants.com/pev/#/plans http://tatiyants.com/pev/#/plans (Postgres Explain Visualizer) When dealing with query optimization in practice, it helps a lot since it enables a clear, convenient and synthetic view of an EXPLAIN (ANALYZE). Just yesterday, it helped me improve a big analytic query from executing in 10 minutes to 5 seconds by just adding a small index.

alexpetralia 8y ago

One more vote for use-the-index-Luke. Clear, concise and comprehensive - I used this quite a bit when studying for interviews or optimizing database performance. Great resource!

frosted-flakes 8y ago
His book (SQL Performance Explained) is also very good. The book is not too long and not too dense. I'd buy it again (in fact, I probably will, because I left my copy with a former employer because they paid for it).

wenc 8y ago

I was introduced to Markus' work by way of Wes McKinney's Twitter link [1]. This is deeper SQL-fu that many of us typically encounter. Highly recommend. [1] https://twitter.com/wesmckinn/status/564526251591733248 https://twitter.com/wesmckinn/status/564526251591733248

miluge 8y ago

I used your website to relearn SQL for work! I can't thank you enough for it and getting promoted.

tmm84 8y ago

I love use the index luke. Some of the best query advice I can get when I have to get something done faster. Personally, the most important part of getting advanced with SQL is being able to vizualize the DB in your mind and how the query should look. Also, sometimes bad design is at fault than a query. If the design is too complicated or wrong a query is gonna be slow in relation to the amount of data it has to go over.

kakwa_ 8y ago

It's a bit off topic since it's not a resource for learning, but: http://tatiyants.com/pev/#/plans http://tatiyants.com/pev/#/plans (Postgres Explain Visualizer) When dealing with query optimization in practice, it helps a lot since it enables a clear, convenient and synthetic view of an EXPLAIN (ANALYZE). Just yesterday, it helped me improve a big analytic query from executing in 10 minutes to 5 seconds by just adding a small index.