178k views
0 votes
The dbms ____ the sql query and chooses the most efficient access/execution plan.

2 Answers

2 votes
The DBMS parses the SQL query and chooses the most efficient access or execution plan.
User Bruce Alderman
by
6.6k points
2 votes
#1) The dbms ____ the sql query and chooses the most efficient access/execution plan.
Answer: Parses. Query Parsing or Query Processing would meant the entire process or activity which involves query translation into low level instructions, query optimization to save resources, cost estimation or evaluation of query, and extraction of data from the database.
User Marabu
by
6.1k points