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.

BY Best Interview Question ON 20 Feb 2019