CHAPTER
5
SQL Plan Management
Oracle DBAs and database developers have for many years counted on tuning SQL statements by examining and refining the internal database engine’s SQL optimizer execution plans, which are often colloquially referred to as “explain plans,” even though “execution plans” is a far more accurate name. Since it’s generally accepted that many, if not most, database performance issues result from executing inefficient or resource-intensive SQL code, execution plan understanding has become a central tuning technique. As such, execution plans are often analyzed as part of development unit testing, peer code reviews, stress ...
Get Oracle Database 12c Release 2 Testing Tools and Techniques for Performance and Scalability now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
