News for hackers. Stuff that matters.
Re:Speeding up SQL queries by orders of magnitude using UNION by mongol on Sunday March 21, 2021 @02:06AM (#26528443)
What is the best book to learn performant SQL querying? I recently needed to query a large database for exploratory purposes. The database has historical data about many years of sales transactions of a huge company. It is using partitioning keys. I know pretty well how to write queries to get what I want but given the size of the database I need to write them performantly. How can I learn that best?
Re:Speeding up SQL queries by orders of magnitude using UNION by sqldba on Sunday March 21, 2021 @03:18AM (#26528696)
SQL Performance Explained, hands-down https://sql-performance-explained.com/

Covers all the main DBMS, explained very simply from the bottom up, maintained constantly and has been read and recommended by people for years and years.