1 of 1 people found the following review helpful
Verified Purchase(What is this?)
This review is from: SQL Performance Explained (Paperback)
I have a database with 7.5 million records and I was struggling with a query that was taking about 1 minute, 30 seconds to execute. 43 pages in and it is now executing in 3 seconds.
This is exactly the result I was looking for.
This is a technical book, aimed specifically at application developers, however it is well written and is not too heavy on the guts of databases.
The first part of the book explains indexing very clearly and very simply. It then goes on to highlight the finer points of joins, sorting, clustering etc.
Worked for me.