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, and we need to understand Oracle internals in order to make things work ...
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.
