• Menu
  • Skip to right header navigation
  • Skip to main content
  • Skip to secondary navigation
  • Skip to primary sidebar

OnlineProgrammingBooks.com

Legally Free Computer Books

  • All Categories
  • All Books
  • All Categories
  • All Books
  • About Us
  • Privacy policy
  • Disclaimer
  • Subscribe
  • Contact
You are here: Home ▶ SQL ▶ SQL Indexing and Tuning Book: Use the Index, Luke!

SQL Indexing and Tuning Book: Use the Index, Luke!

April 3, 2012

Free Online SQL Indexing and Tuning Book: Use the Index, Luke!

“Use the Index, Luke!: A guide to database performance” is a free online SQL indexing and tuning book by Markus Winand. This book is for developers; it avoids unnecessary details about database internals.

Book Description

This book covers everything developers need to know about indexes—and nothing more. To be more precise, the book covers the most important index type only: the B-Tree index. The B-Tree index works almost identical in various databases. The book uses the terms of the Oracle database only, but the principles apply to other databases as well. Side notes provide relevant information for MySQL, PostgreSQL and Microsoft SQL Server.

The structure of the book is tailor-made for developers; most of the chapters correspond to a specific part of an SQL statement.

Table of Contents

  • Anatomy of an Index
  • The Where Clause
  • Testing and Scalability
  • The Join Operation
  • Clustering Data
  • Sorting and Grouping
  • Partial Results
  • Insert, Delete and Update
  • To Be Continued
  • Execution Plans
  • Myth Directory
  • Glossary
  • Example Schema

Download Free PDF / Read Online

Author(s): Markus Winand
Format(s): HTML
Link: Read online.

Similar Books:

  1. MySQL Essentials
  2. Health Data in the Information Age
  3. The Little MongoDB Book
  4. Java Data Structures (2nd edition)
  5. Database fundamentals
Previous Post: « Learn Prolog Now!
Next Post: Patterns from O’Reilly Media’s Designing Social Interfaces »

Primary Sidebar

Get Latest Updates

  • Facebook
  • Pinterest
  • RSS
  • Twitter
  • YouTube
  • About Us
  • Privacy policy
  • Disclaimer
  • Subscribe
  • Contact

Copyright © 2006–2023 OnlineProgrammingBooks.com