SQL Performance Explained

✍ Scribed by Markus Winand

Publisher: Markus Winand (2012)
Year: 2012
Tongue: English
Leaves: 207
Edition: Paperback
Category: Library

No coin nor oath required. For personal study only.

✦ Synopsis

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.

📜 SIMILAR VOLUMES

SQL Performance Explained Everything Dev

📁 SQL Performance Explained Everything Developers Need to Know about SQL Performance

✍ Markus Winand 📂 Library 📅 2023 🏛 Markus Winand 🌐 English

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

SQL Performance Explained (vol. 1: Basic

📁 SQL Performance Explained (vol. 1: Basic Indexing)

✍ Markus Winand 📂 Library 📅 2011 🏛 use-the-index-luke.com 🌐 English

SQL Clearly Explained

📁 SQL Clearly Explained

✍ Harrington, Jan L 📂 Library 📅 2010 🏛 Elsevier Science;Morgan Kaufmann 🌐 English

SQL Explained, Third Edition, provides an in-depth introduction to using SQL (Structured Query Language). Readers will learn not only SQL syntax, but also how SQL works. Understanding the how as well as the what will aid in creating SQL statements that execute as quickly as possible. <br>The book is

SQL Clearly Explained

📁 SQL Clearly Explained

✍ Jan L. Harrington 📂 Library 📅 2003 🏛 Morgan Kaufmann 🌐 English

Explaining Explanation

📁 Explaining Explanation

✍ David-Hillel Ruben 📂 Library 📅 1992 🏛 Routledge 🌐 English

In Explaining Explanation, David-Hillel Ruben provides a non-technical discussion of some of the main historical attempts to explain the concept of explanation, examining the works of Plato, Aristotle, John Stuart Mill, and Carl Hempel. Building on and developing the insights of these historical fig

Explaining explanation

📁 Explaining explanation

✍ Ruben, David-Hillel 📂 Library 📅 2016 🏛 Routledge 🌐 English

I. Getting our bearings -- II. Plato on explanation -- III. Aristotle on explanation -- IV. Mill and Hempel on explanation -- V. The ontology of explanation -- VI. Arguments, laws, and explanation -- VII. A realist theory of explanation.