SQL Performance Tuning Errata

This page contains errata and information that became available after we went to print.
Note that the SQL examples in SQL Performance Tuning are written in ANSI/ISO SQL:1999 rather than in SQL:2003 because SQL:2003 was not approved at time of writing.

New stuff for CHAPTER 2 SIMPLE SEARCHES
Page 32: Portability note -- MySQL uses REGEXP, with slightly different pattern wildcards, instead of SIMILAR.

New stuff for CHAPTER 7 COLUMNS
Page 146: Minimum Date Value sidebar -- (a) 1753 is the year after the Gregorian calendar became official in England and America. (b) The start date of the Julian period was calculated by Joseph Scaliger, not by Julius Scaliger. (Julius was Joseph's father.) (c) Oracle's calendar is not proleptic.
Page 148: Table 7-5 ANSI/DBMS Integer Support -- SQL:2003 will support the BIGINT data type.
Page 151: Floats -- DOUBLE is not a valid synomym for the DOUBLE PRECISION data type.
Page 161: Table 7-11 ANSI/DBMS Bit Support -- SQL:2003 will remove support for the BIT and BIT VARYING data types.

New stuff for CHAPTER 9 INDEXES
Page 233: Covering Indexes -- In fact a DBMS such as DB2 may use covering indexes for joins or groupings.

New stuff for CHAPTER 11 STORED PROCEDURES
Page 286: Listing 11-1 states that stored procedure names typically begin with Sp_. This naming method is not recommended if you use Microsoft SQL Server.

New stuff for CHAPTER 13 JDBC
Page 359ff: Our paragraph on the getShort Java method states that -32768 is a legal value for getShort but not for its SQL equivalent, SMALLINT. SQL:2003 will agree with Java.

New stuff for APPENDIX B GLOSSARY
Page 455: Our SQL glossary has been moved to www.ocelot.ca/glossary.htm.
Page 464: The definition for the join expression entry should be:
The WHERE or ON clause search condition that tells the DBMS over which columns it is to join two tables.
Page 464: The definition for the JVM entry should be:
Java Virtual machine, a platform-independent environment that converts Java bytecode into machine language and executes the result.
Page 467: The definition for the OLTP entry should be:
Online Transaction Processing, a type of computer processing in which the system responds to user requests.



HOW TO ORDER


You can call your local bookstore. Tell them the title is "SQL Performance Tuning"; the authors are "Peter Gulutzan & Trudy Pelzer"; the publisher is "Addison-Wesley"; and the ISBN is"0-201-79169-2".


You can order from the publisher. To order multiple copies or ask about textbook pricing, go to Addison-Wesley's site.


You can order from amazon. If you're in North America, go to amazon.com now.




Copyright (c) 2002-2003 by Ocelot Computer Services Inc. All rights reserved.

Return to Ocelot home page
Return to tuning.htm page