State the different steps of query processing in a DDBMS.
Answers
Answered by
1
A given SQL query is translated by the query processor into a low level program called an execution plan
An execution plan is a program in a functional language
The physical relational algebra extends the relational algebra with primitives to search through the internal storage structure of DBMS.
Basic Steps in Query Processing
1.Parsing and translation
2.Optimization
3.Evaluation
Similar questions