Oracle Transaction - Dec 03, 2008 at 15:00 PM by Rajmeet Ghai
Explain the steps executed during SQL statement processing.
-
The parser scans the statement and breaks it into logical units such as
keywords, identifiers and operators.
-
A query or a sequence tree is built using the units above. This is done to
transform the source data into the format required by the result set.
-
The Query optimizer analyzes the fastest way to access the source tables using
minimum resources. The final optimized version of the updated query tree is
called as execution plan.
-
Now, the relational engine starts to execute this plan. the relational engine
requests that the storage engine pass up data from the row sets requested from
the relational engine.
-
In turn, the relational engine processes this data into the format as desired
by result set and returns the same.
The answers to following questions will be made
available soon. Keep visiting.
What are the steps executed during a typical transaction?
|