© Jon Heller 2019
Jon HellerPro Oracle SQL Development https://doi.org/10.1007/978-1-4842-4517-0_17

17. Understand SQL Tuning Theories

Jon Heller1 
Clive, IA, USA

Algorithm analysis was a useful guide for understanding the foundations of Oracle performance. Now we must turn to the more traditional techniques and theories of database performance. First we need to discuss performance issues from the end user’s perspective. Then we will discuss several popular approaches to performance tuning. But all roads eventually lead to SQL tuning. For effective SQL tuning we need to understand the importance of execution plans, the operations available in execution plans, cardinality, optimizer statistics, transformations, and dynamic optimization features. ...

Get Pro Oracle SQL Development: Best Practices for Writing Advanced Queries 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.