This book is a revision of the successful guide to DB2. It presents proven techniques required to produce DB2 applications with high performance characteristics. It has been updated to cover the new Release 2.3 of DB2 and the depth of coverage has been expanded throughout the seventeen chapters of the book. It also contains new and unique coverage of programming for performance, optimization, and the EXPLAIN command. Highlights: Provides indepth and expanded coverage of performance. Provides hints, tips, and guidelines for the design and development of application systems. Conveys and understanding of SQL processing to maximize the performance so that the guidelines can be applied to your specific application system. Incorporates new features of Release 2.3 throughout the book. Contains a new chapter on program preparation and execution detailing how to use packages and plans, including fall back procedures. This book is an excellent resource for professional database designers and developers. It is concise and easy to read--making it an understandable guide for beginners as well. 0201580497B04062001