Author(s): Tapio Lahdenmaki, Michael Leach
Publisher: Wiley
Year: 2005
ISBN: 0-471-71999-4
Language: English
File type: PDF
Pages: 326
Size (for download): 4.95 MB

The audience for which this book is intended, is quite literally, anyone who feels it is to his or her benefit to know something about SQL performance or about how to design tables and indexes effectively, as well as those having a direct responsibility for designing indexes, anyone coding SQL statements as queries or as part of application programs, and those who are responsible for maintaining the relational data and the relational environment. All will benefit to a varying degree if they feel some responsibility for the performance effects of what they are doing.

Relational databases have been around now for more than 20 years. In their early days, performance problems were widespread due to limited hardware resources and immature optimizers, and so performance was a priority consideration. The situation is very different nowadays; hardware and software have advanced beyond all recognition. It’s hardly surprising that performance is now assumed to be able to take care of itself! But the reality is that despite the huge growth in resources, even greater growth has been seen in the amount of information that is now available and what needs to be done with this information.

Additionally, one crucial aspect of the hardware has not kept pace with the times: Disks have certainly become larger and incredibly cheap, but they are still relatively slow with regards to their ability to directly access data. Consequently many of the old problems haven’t actually gone away—they have just changed their appearance. Some of these problems can have enormous implications—stories abound of “simple” queries that might have been expected to take a fraction of a second appear to be quite happy to take several minutes or even longer; this despite all the books that tell us how to code queries properly and how to organize the tables and what rules to follow to put the right columns into the indexes. So it is abundantly clear that there is a need for a book that goes beyond the usual boundaries and really starts to think about why so many people are still having so many problems today.


TABLE OF CONTENT:
Chapter 01 - Introduction
Chapter 02 - Table and Index Organization
Chapter 03 - SQL Processing
Chapter 04 - Deriving the Ideal Index for a SELECT
Chapter 05 - Proactive Index Design
Chapter 06 - Factors Affecting the Index Design Process
Chapter 07 - Reactive Index Design
Chapter 08 - Indexing for Table Joins
Chapter 09 - Star Join Considerations
Chapter 10 - Multiple Index Access
Chapter 11 - Indexes and Reorganization
Chapter 12 - DBMS-Specific Indexing Restrictions
Chapter 13 - DBMS-Specific Indexing Options
Chapter 14 - Optimizers Are Not Perfect
Chapter 15 - Additional Estimation Considerations
Chapter 16 - Organizing the Index Design Process