Tags
Language
Tags
December 2024
Su Mo Tu We Th Fr Sa
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 31 1 2 3 4

SQL Performance Explained: Everything Developers Need to Know about SQL Performance by Markus Winand

Posted By: lengen
SQL Performance Explained: Everything Developers Need to Know about SQL Performance by Markus Winand

SQL Performance Explained: Everything Developers Need to Know about SQL Performance by Markus Winand
English | 2012 | ISBN: 3950307826 | 204 Pages | PDF | 1.2 MB

This book 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.
SQL indexing is the most effective SQL tuning method and requires the same care as schema design yet it is often neglected during development.
Starting with the basics of indexing and the WHERE clause, it guides developers through all parts of an SQL statement and explains the pitfalls of object-relational mapping (ORM) tools like Hibernate.
Its systematic structure makes this book both a textbook and a reference manual that should be on every developer's bookshelf.