Oracle SQL Execution Process

1.sql Execution Process

1> parsing (determining whether an object exists, whether there are permission queries, semantic parsing, checking the cache for the same SQL, and so on)

2> optimization (CBO determines the optimization mode, determines the access path, the join sequence, the process through a number of comprehensive factors to estimate the various ways of resource consumption, the selection of the lowest consumption of excellent)

3> generating QEP (query execution plan: querying execution Plan)

4> Execute QEP, return result

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M01/88/FB/wKiom1gDfHGyswFrAAGVtfGh9DI418.png "title=" o6l{(0 ) q]~@) 3ct@r}qe7o6.png "alt=" Wkiom1gdfhgyswfraagvtfgh9di418.png "/>

This article is from the "Linux Little Boy" blog, please be sure to keep this source http://zjwliunx.blog.51cto.com/11010135/1862451

Oracle SQL Execution Process