SQL Performance Explained
Everything developers need to know about SQL performance
Markus Winand(Author)
Winand, Markus (Publisher)
Published on 30. July 2012
Book
Paperback/Softback
204 pages
978-3-9503078-2-5 (ISBN)
Description
SQL Performance Explained helps developers to improve database performance. The focus is on SQL-it covers all major SQL databases without getting lost in the details of any one specific product.
Starting with the basics of indexing and the WHERE clause, SQL Performance Explained guides developers through all parts of an SQL statement and explains the pitfalls of object-relational mapping (ORM) tools like Hibernate.
Topics covered include: Using multi-column indexes Correctly applying SQL functions Efficient use of LIKE queries Optimizing join operations Clustering data to improve performance Pipelined execution of ORDER BY and GROUP BY Getting the best performance for pagination queries Understanding the scalability of databases
Its systematic structure makes SQL Performance Explained both a textbook and a reference manual that should be on every developer's bookshelf.
Starting with the basics of indexing and the WHERE clause, SQL Performance Explained guides developers through all parts of an SQL statement and explains the pitfalls of object-relational mapping (ORM) tools like Hibernate.
Topics covered include: Using multi-column indexes Correctly applying SQL functions Efficient use of LIKE queries Optimizing join operations Clustering data to improve performance Pipelined execution of ORDER BY and GROUP BY Getting the best performance for pagination queries Understanding the scalability of databases
Its systematic structure makes SQL Performance Explained both a textbook and a reference manual that should be on every developer's bookshelf.
More details
Language
English
Target group
Professional and scholarly
Dimensions
Height: 23 cm
Width: 15 cm
Weight
340 gr
ISBN-13
978-3-9503078-2-5 (9783950307825)
Schweitzer Classification
Person
Markus Winand has been developing SQL applications since 1998. His main interests include performance, scalability, reliability, and generally all other technical aspects of software quality. Markus currently works as an independent trainer and coach in Vienna, Austria.