Articles tagged ANSI SQL

09 July 2014
09 July 2014

Execution Plans Part 7: Query Blocks and Inline Views

When we examine an execution plan, we’re usually trying to work out the mechanical steps that Oracle took to produce a result set. When we do this, it’s important to remember that the text that Oracle optimized wasn’t necessarily the same as the statement we originally wrote. Oracle may have transformed our statement before passing it through the optimization engin… Read more