SQL Performance Explained

Brand Details

Type: Product

Description: SQL Performance Explained is a book by Markus Winand that helps developers improve database performance by focusing on SQL. It covers major SQL databases without getting bogged down in the specifics of any single product. The book starts with fundamental concepts like indexing and the WHERE clause, then progresses through various aspects of SQL statements, addressing common pitfalls of object-relational mapping (ORM) tools such as Hibernate. Topics include multi-column indexes, efficient use of SQL functions and LIKE queries, optimizing join operations, data clustering for performance improvement, pipelined execution of ORDER BY and GROUP BY, optimizing pagination queries, and understanding database scalability. Its structured format makes it suitable as both a textbook and a reference manual.

Website: Not available