© Jon Heller 2019
Jon HellerPro Oracle SQL Development https://doi.org/10.1007/978-1-4842-4517-0_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 orders of magnitude difference in skill level between professionals. We’ve all had to deal with ...

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.