Please enable JavaScript.
Coggle requires JavaScript to display documents.
sql query processing - Coggle Diagram
sql query processing
sql query
Parser/Transalator
Optimiser
Excution Engine
Data
Finally runs the query and display the required result
DataBase Catalog
Row sourcing Generation
The Row Source Generation is a software that receives a optimal execution plan from the optimizer and produces an iterative execution plan that is usable by the rest of the database
A database must perform a hard parse ,it is is a process in which multiple query execution plan for satisfying a query are examined and most efficient query plan is satisfied for execution.
Shared Pool check
Syntax Check
concludes SQL syntactic validity. Example:
SELECT * FORM employee
Here error of wrong spelling of FROM is given by this check.
Sematic Check
– determines whether the statement is meaningful or not. Example: query contains a tablename which does not exist is checked by this check.
(please click on the link below for video)
https://drive.google.com/file/d/14cYKWB68A4UyridAmFGaxpJ97xQDdP7t/view?usp=drivesdk