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?
[ Parent
| on HN ]
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.