Sql query to db s/w operation
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
