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_18

18. Improve SQL Performance

Jon Heller¹  

(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, ...