I found <i>Use the Index, Luke</i> interesting, but I don't know much SQL. I wonder how this book compares.<p><a href="https://use-the-index-luke.com/" rel="nofollow">https://use-the-index-luke.com/</a>
I haven't read the book but it has 5 stars with 19 reviews on Amazon. <a href="https://www.amazon.com/Performance-Explained-Everything-Developers-about/dp/3950307826" rel="nofollow">https://www.amazon.com/Performance-Explained-Everything-Deve...</a>
I sort of have a beef with the usage of "SQL performance". I know what people mean, but it still irks me.<p>SQL is a declarative query language. It describes the meaning of your query.<p>The execution of the query has performance implications based on the actual RDBMS and the semantics of the query, but you can't improve the performance of your query without altering its meaning, only the performance of its execution.<p>It's like when people describe the performance of Python when they mean the performance of the CPython runtime.