IBM's DB2 has surpassed Oracle to become the #1 enterprise database. Now, there's a comprehensive core book on DB2, including coverage of the not-yet-released Version 7 of DB2: its key characteristics, and how to tune it for maximum performance. Written by world-renowned DB2 consultants Richard Yevich and Susan Lawson -- and endorsed by DB2 Chief Architect Roger Miller -- this book delivers the most thorough, real-world optimization information ever published, for both developers and administrators. Coverage includes: DB2 high-performance design for both OLTP and OLAP applications; practical techniques for improving the efficiency of SQL; working with the DB2 Optimizer; DB2 data sharing implementation and performance; triggers, stored procedures, UDFs, and other advanced DB2 programming techniques; and specific coverage of optimizing data warehouses and enterprise applications.