Re: New advanced book on index design

From: BobTheDataBaseBoy <"xxx>
Date: Sun, 21 Aug 2005 23:27:15 -0400
Message-ID: <08udnQIPUL1J2JTeRVn-hw_at_rcn.net>


Lauri wrote:
> There is a new book on indexing SQL-DBMS'es
> by Tapio Lahdenmaki and Michael Leach.
>
> Relational Database Index Design and the Optimizers
> See
> http://tinyurl.com/84g95
> (Amazon-link)
>
> It is probably a bit heavy for beginners
> but experienced DBA's should find this
> book very usefull.
>
> Tapio Lahdenmäki is my performance "guru"
> and I have learned maybe 80% of what I know
> about DBMS-performance from him.
>
> regards,
> Lauri Pietarinen

saw the title, intrigued (and get a massive discount since The Wife works at a bookstore), got it.

couple of points i don't like:

the authors treat a RDBMS from the point of view of COBOL cursor traversal.

they don't spend any time discussing how to force buffer writes to commits; the source of real performance (a bit on the edge, sure).

there's no math of significance.

the Tow or Gulutzan books provide (mutually different) points of view on   performance. you really need all three. not to mention your vendor manuals.

BTDB Received on Mon Aug 22 2005 - 05:27:15 CEST

Original text of this message