Title: SQL Performance Explained Everything Developers Need to Know about SQL Performance
Publisher: Markus Winand (2012)
Publication Date: 2012
Language: English
ISBN 10: 3950307826
ISBN 13: 9783950307825
Binding: paperback
Weight: 12 ounces

About this title

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.

Covers all major databases: Oracle� Database, SQL Server�, PostgreSQL, MySQL

What readers say:
“This book is definitively worth having in the company library.” — Joe Celko

"About this title" may belong to another edition of this title.

Store Description

We sell a wide range of new and used fiction and non fiction. We have both new items and out of print items.

Visit Seller's Storefront

Seller's business information

Opportunity Knocks Media Management LLC
863 Ardiano Avenue, Tontitown, AR, 72762, U.S.A.

Sale & Shipping Terms

Terms of Sale

Shipping Terms

We ship within 48 hours of your order. We happily take returns for 30 days.

Shipping rates within U.S.A.

Shipping rates within U.S.A.
Order quantity	5 to 14 business days	3 to 6 business days
First item	US$ 3.99	US$ 6.75

Delivery times are set by sellers and vary by carrier and location. Orders passing through Customs may face delays and buyers are responsible for any associated duties or fees. Sellers may contact you regarding additional charges to cover any increased costs to ship your items.