Advanced Oracle SQL Tuning: The Definitive Reference (Oracle In-Focus series)

This manual teaches senior Oracle professionals to explore the internal mechanisms within Oracle and the powerful and complex internals of Oracle SQL execution. Understanding that SQL tuning is crucial for properly tuning an Oracle database and thereby ensuring optimal execution speed, this book explains internal and external factors that affect the SQL processing engine and its execution speed. Through statistics and histograms, this valuable guide teaches how to optimize SQL tuning using real-world tips and techniques.