What do you mean by query optimization?

1.	What do you mean by query optimization?
Answer» A single query can be solved or executes by WRITING DIFFERENT query plans or ALGORITHMS. Query optimization is a process in which the query optimizer chooses the most efficient algorithm to perform the GIVEN query. 13. What do you mean by denormalization? The denormalization is an optimization process to INCREASE the data redundancy in the database. As a result, the joins are avoided, and the performance of the database structure is improved. Denormalization is done after the normalization process.

Answer»

A single query can be solved or executes by WRITING DIFFERENT query plans or ALGORITHMS. Query optimization is a process in which the query optimizer chooses the most efficient algorithm to perform the GIVEN query.

13. What do you mean by denormalization?

The denormalization is an optimization process to INCREASE the data redundancy in the database. As a result, the joins are avoided, and the performance of the database structure is improved. Denormalization is done after the normalization process.

Discussion

No Comment Found

Related InterviewSolutions

What do you mean by starvation in DBMS?
What do you mean by conflict Serializability in DBMS?
What is a concurrency problem in DBMS?
What is the difference between DELETE and TRUNCATE command in DBMS?
What is acid property in DBMS?
What is BCNF standard form in DBMS?
What do you mean by checkpoints in DBMS?
What do you mean by DML Compiler?
What is index and also its types in DBMS?
What is data Independence and also explain its types?