Generally, there are 3 operations between sql query and database s/w ie.,  Parse, Execute and Fetch

  • Parse operation: in this database engine receives the query and checks the syntax of query by compiling the query
  • Execute operation: in this process database engine executes the compiled query and the generated results will be stored in the buffer
  • Fetch operation: in this process database engine collects the results from the buffer and sends to client application