Database Performance Tuning and Optimization

Viac o knihe

Focusing on database performance tuning and optimization, this book utilizes Oracle 8i as a case study while providing theoretical insights and practical SQL scripts. It caters to both DBAs and developers, allowing those using different RDBMS systems to apply the principles with their own scripts. The text explores the three operational database levels—conceptual, internal, and external—highlighting how data modeling and logical design translate into practical implementation. Each script is tested for accuracy, complete with sample outputs for user reference.