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, ...
© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023
J. HellerPro Oracle SQL Development https://doi.org/10.1007/978-1-4842-8867-2_1717. Understand SQL Tuning Theories
Jon Heller1
(1)
Clive, IA, USA
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.
