7 ms·
I have found that Use The Index, Luke is a good reference when looking at optimizations. It's also nice that it covers most of the major SQL databases, so you
by dsp1234 10y ago
I have found that Use The Index, Luke is a good reference when looking at optimizations. It's also nice that it covers most of the major SQL databases, so you can see differing optimizations and how to handle them.
http://use-the-index-luke.com/sql/preface http://use-the-index-luke.com/sql/preface
- jpitz 10y agoThat is a great resource. Here are some I've used: Inside Microsoft SQL Server 2008 T-SQL Querying: T-SQL Querying https://books.google.com/books?id=FZlCAwAAQBAJ&printsec=frontcover#v=onepage&q&f=false https://books.google.com/books?id=FZlCAwAAQBAJ&printsec=fron... Good resource for designing high performing queries and investigating performance problems. PostgreSQL 9.0: High Performance https://books.google.com/books?id=OWOAu0GcsqoC&printsec=frontcover#v=onepage&q&f=false https://books.google.com/books?id=OWOAu0GcsqoC&printsec=fron... Greg lays out a great foundation for doing performance analysis that is largely applicable to any rdbms platform. Optimizing Oracle Performance https://books.google.com/books?id=D7ElCwAAQBAJ&printsec=frontcover#v=onepage&q&f=false https://books.google.com/books?id=D7ElCwAAQBAJ&printsec=fron... Another great book that explains the process of approaching and solving performance problems. Joe Celko's SQL For Smarties https://books.google.com/books?id=i-19BAAAQBAJ&printsec=frontcover#v=onepage&q&f=false https://books.google.com/books?id=i-19BAAAQBAJ&printsec=fron... Everyone writing SQL should read Joe.
- icc97 10y agoWhat intrigues me about Joe Celko's book is that he is completely anti all forms of auto indexing (and it makes sense) but is the assumption for all the web frameworks that I come across. Most recently I hit this when looking at yesod.