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_10

10. Optimize the Database with Oracle Architecture

Jon Heller¹  

(1)

Clive, IA, USA

 

SQL and the relational model are logical constructs built on top of our slow, physical machines. Even E. F. Codd’s original paper warned that implementing the relational model would run into physical limitations. The more advanced features we use and the more stress we put on the database, the more likely it is for Oracle’s abstractions to fail. Oracle has put a lot of effort into making our SQL code atomic, consistent, isolated, and durable. But no system can hide all of its implementation details, ...