What books are there about SQL query optimization?

Question

Database

Now at work I often come across huge selections from the database and, unfortunately, I could not find serious documentation on optimizing SQL queries on the Internet. Most of the articles talk only about general provisions and tips, while being very vague. Does anyone have useful links or book titles that will help you understand how to build database queries?
I would be grateful for any information)

Answer 1

Martin Gruber
Understanding SQL

Answer 2

Stéphane Faro, Pascal Lermy - Refactoring SQL Applications

Answer 3

K. J. Date. - SQL and relational theory. How to Write SQL Code Properly

Answer 4

SQL database programming. Common Errors and Troubleshooting, Karvin B. - 2012
MySQL. Performance Optimization, Schwartz B., Zaitsev P., Tkachenko V., 2th - 2010

Answer 5

If you work with Oracle, then:
- Tom Kite, Oracle for professionals
- Lewis, "Principles of cost optimization"

Answer 6

What dialect do you use? If t-sql, that is, your personal list, of books on Amazon (get ready to spend money), read in the indicated order, except for paragraph 2 (released later)
Microsoft SQL Server 2012 T-SQL Fundamentals (Deve... (used more or less universal code, taking into account the standard)
T-SQL Querying (Developer Reference) (did not read, but according to the description it looks like a mixture of the book from paragraph 1 and another work of the author Training Kit (Exam 70-461) Querying Microsoft SQL ... )
SQL Server Execution Plans (can be found officially free in pdf)
SQL Server Query Performance Tuning
There are blogs like www.simple-talk and sqlservercentral

Answer 7

www.depesz.com/?s=EXPLAINING+THE+UNEXPLAINABLE
https://wiki.postgresql.org/images/4/45/Explaining...