Quantity:

More Buying Choices

25 used & new from �48.91

Have one to sell? Sell yours here

Relational Database Index Design and the Optimizers (Hardcover)

by Tapio Lahdenmaki (Author), Mike Leach (Author) "Relational databases have been around now for over 20 years, and that's precisely how long performance problems have been around too-and yet here is another..." (more)

5.0 out of 5 stars See all reviews (1 customer review)

RRP:	�64.50
Price:	�61.28 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save:	�3.22 (5%)
	o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o

In stock.
Dispatched from and sold by Amazon.co.uk. Gift-wrap available.

Only 1 left in stock--order soon (more on the way).

Want guaranteed delivery by Wednesday, November 11? Choose Express delivery at checkout. See Details

17 new from �48.91 8 used from �49.72

Frequently Bought Together

Customers Who Bought This Item Also Bought

Windows Internals 5th Edition (PRO-Developer)

by Mark E. Russinovich and David A. Solomon with Alex Ionescu

5.0 out of 5 stars (4) �31.97

RMAN Recipes for Oracle Database 11g: A Problem-Solution Approach (Expert's Voice in Oracle)

by D et al Kuhn

�32.36

Applied Mathematics for Database Professionals (Expert's Voice)

by L & Koppelaars, T de Haan

5.0 out of 5 stars (3) �33.99

Oracle Database 10g RMAN Backup & Recovery (Osborne Oracle Press Series)

by Matthew Hart

�27.93

Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning: A Practical Guide to Performance Diagnostics and Tuning (Osborne Oracle Press Series)

by Richmond Shee

5.0 out of 5 stars (1) �14.99

› Explore similar items

Product details

Hardcover: 328 pages
Publisher: WileyBlackwell (16 Sep 2005)
Language English
ISBN-10: 0471719994
ISBN-13: 978-0471719991
Product Dimensions: 23.6 x 15.5 x 2.3 cm

Average Customer Review: 5.0 out of 5 stars See all reviews (1 customer review)

Amazon.co.uk Sales Rank: 512,288 in Books (See Bestsellers in Books)

Would you like to update product info or give feedback on images?

See Complete Table of Contents

Customers Viewing This Page May Be Interested in These Sponsored Links

(What is this?)

Database Development - UK opens new browser window

www.amtdatatechnologies.com - SQL Server, XML, .NET, Web Services Quality Development or Optimisation

Database Development opens new browser window

ApprovedDatabaseDevelopers.co.uk - Get free quotes from 4 leading UK Database Development companies

Optimize SQL Performance opens new browser window

www.Embarcadero.com - Quickly find & fix SQL performance issues with DBOptimizer. Free trial

Product Description

Review

"I recommend this book to all those who have anything to do with database performance. It is a must–read for all database administrations, database designers, performance–tuning specialists, and application programmers…" (Computing Reviews.com, November 20, 2005)

Review

See all Product Description

Inside This Book (Learn More)

First Sentence
Relational databases have been around now for over 20 years, and that's precisely how long performance problems have been around too-and yet here is another book on the subject. Read the first page

Explore More
Concordance

Suggested Tags from Similar Products

(What's this?)

Be the first one to add a relevant tag (keyword that's strongly related to this product)

optimization

database

What Do Customers Ultimately Buy After Viewing This Item?

	81% buy the item featured on this page: Relational Database Index Design and the Optimizers 5.0 out of 5 stars (1) �61.28
	10% buy Applied Mathematics for Database Professionals (Expert's Voice) 5.0 out of 5 stars (3) �33.99
	9% buy SQL Tuning �18.89

Explore similar items

Customer Reviews

1 Review

5 star:		(1)
4 star:		(0)
3 star:		(0)
2 star:		(0)
1 star:		(0)

Average Customer Review

5.0 out of 5 stars (1 customer review)

Share your thoughts with other customers:

Create your own review

Most Helpful Customer Reviews

12 of 13 people found the following review helpful:

5.0 out of 5 stars Performance by indexing, 17 Jan 2008

By	J. P. Lewis (London, England, UK) - See all my reviews (REAL NAME)

Before I start commenting on this book, I should point out that I have been using, running, designing, or trouble-shooting Oracle database systems for most of the last 20 years - but the authors have a background in DB2.

Having made said that, the difference in RDBMS really doesn't matter. If you are responsible for making databases perform well you should read this book.

It tells you why you need to create indexes - and the answer is a little more subtle than just "to make things go faster"; it tells you how to decide on the columns to include in your indexes; it tells you how to choose the best order for those columns; and it describes the compromises you make between a reasonable set of pretty good indexes and the complete set of ideal indexes

Experienced DBAs may read this book and decide that it's not telling them anything new. Even if you fall into this group, don't use that as an excuse for putting the book to one side. The clarity of explanation, the rational justification, and the numerical approximation methods supplied by this book should give you a better insight - hence greater effectiveness - into what may at present be an intuitive approach to deciding on indexing strategies.

The book gives you useful models for working out the benefit of adding, or modifying, an index in terms of how much work you do as you walk through the index and visit the table. It gives you a simple system for classifying an index with one, two, or three stars, and then offers an insight into when you may or may not,want to create the ideal index for a query.

Specifically for the Oracle practitioner, I found a few minor details that required a slight mental adjustment: the authors tend to talk about 4Kb block sizes with relatively large index entries whereas many Oracle systems tend to use 8Kb block sizes with relatively small index entries; there were points where the experienced Oracle DBA would want to think about allowing for the background workload due to UNDO and REDO; there were details where I could see some difference between DB2 and Oracle technology; and the authors also have a section discussing when to rebuild indexes (an activity generally viewed as anathema in the Oracle world).

Given the common Oracle view about index rebuilding - and my background - I feel it is important to say that the authors' arguments are perfectly sound, and I would be quite happy to follow their guidelines; but I would only expect the argument to apply to a very small percentage of the indexes in a typical Oracle (OLTP) system. This is because there was one detail that I thought needed to be raised more explicitly - despite being implicit in a large fraction of the writing - the authors' were talking about small blocks with large index entries for indexes that have been engineered so that critical queries did most of their work IN THE INDEX, making "one more random block read" a significant fraction of the total workload.

These are minor details, though, that have no impact on the general principles; at most they move the boundary line at which you decide whether the cost of any structural change is worth the benefit offered by that change.

In summary - any DBA should read this book if they need to get better performance from a badly indexed database.

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)

Share your thoughts with other customers: Create your own review

› See all customer reviews...

.jsOffDisplayBlock { display: block; } .jsOffDisplayInline { display: inline; } .jsOffVisibility { visibility: visible; } .jsOnDisplayBlock { display: none; } .jsOnDisplayNoneBlock { display: block; } .jsOnDisplayNoneInline { display: inline; } .jsOnDisplayInline { display: none; } .jsOnVisibility { visibility: hidden; } .jqOnDisplayBlock { display: none; } .jqOnDisplayInline { display: none; } .jqOnVisibility { visibility: hidden; } .jqOnDisplayNoneBlock { display: block; } .jqOnDisplayNoneInline { display: inline; }