edited by
328 views
0 votes
0 votes

Which of the component module of $\text{DBMS}$ does rearrangement and possible ordering of operations, eliminate redundancy in query and use efficient  algorithms and indexes during the execution of a query?

  1. query compiler
  2. query optimizer
  3. Stored data manager
  4. Database processor
edited by

1 Answer

0 votes
0 votes
Answer : (option B) Query Optimizer

it is built-in database software that determines the most efficient method for a SQL statement to access requested data.

Related questions

1 votes
1 votes
2 answers
1
4 votes
4 votes
6 answers
3
soujanyareddy13 asked May 12, 2021
1,859 views
The Boolean expression $AB+A \overline{B}+\overline{A}C+AC$ is unaffected by the value of the Boolean variable _________.$A$$B$$C$$A, B$ and $C$