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

18. Improve SQL Performance

Jon Heller1  
(1)
Clive, IA, USA
 

It’s time to use our theories and start building practical SQL tuning solutions. This chapter starts with high-level applications and then drills down through databases and SQL statements, until we get to operations.

Before we start looking for opportunities to improve performance, we all need to agree to do something: stop guessing. We should never have to guess what program is slow, what database is slow, what statement is slow, or what operation is slow. No matter what part of our technology stack we are investigating, ...

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.