© 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_16

16. Understand SQL Performance with Algorithm Analysis

Jon Heller1  
(1)
Clive, IA, USA
 

Solving Oracle SQL performance issues is the pinnacle of SQL development. Performance tuning requires a combination of all the skills previously discussed in this book. We need to understand the development process (to know why problems happened and weren’t caught sooner), advanced features (to find alternative ways to implement code), and programming styles (in order to understand the code and rewrite it into something better).

Programming is one of the few fields with order-of-magnitude difference ...

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.