Pro Oracle SQL Development: Best Practices for Writing Advanced Queries

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023

J. HellerPro Oracle SQL Developmenthttps://doi.org/10.1007/978-1-4842-8867-2_17

17. Understand SQL Tuning Theories

Jon Heller¹  

(1)

Clive, IA, USA

 

Algorithm analysis is 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 to execution plans, cardinality, ...