Thursday, 9 August 2012

Different Stages of an SQL statement - Optimizer


An SQL statement passes through 4 stages.  They are, Parse, bind, execute and fetch.
  •          Parse:
o   Searches for identical statement in the MEMORY,
o   Checks for the syntax, object name and privileges,
o   Locks objects used during parse and
o   Create and store the execution plan.
  •          Bind:
o   Obtains the values for the any host variables [& or &&],
  •          Execute:
o   Process the statement, and
  •          Fetch:
   o   Return rows to the user process.
The optimizer of the server determines the most efficient way to run a SQL statement. This is an important step in the processing of any data manipulation language (DM(Q)L) statement: SELECT, INSERT, UPDATE, MERGE, or DELETE.



5 comments:

  1. It is a known fact that ILLUMINATI consist of Multi Millionaires,Billionaires who have major influence regarding global affairs, and planning of a New world order. Many world leaders, Presidents, prime ministers, royalty and senior executives are members of ILLUMINATI. follow the steps to Excel in Life. you'll have numerous benefits,for the FIRST TIME IN HISTORY, we are opening our doors to those who believe. If you would like to join ILLUMINATI , to sign up Text: leovincey08@gmail.com or whatsapp +2349033667873 now if you are really serious to help your self

    ReplyDelete

Related Posts Plugin for WordPress, Blogger...

ShareThis