My Suggestion What Is Meant By Query Optimization?

sinGN

Well-Known Member
It attempts to determine the most efficient way to execute a given query by considering the possible query plans.
 

Theomax

Member
A query optimizer is a critical database management system (DBMS) component that analyzes Structured Query Language (SQL) queries and determines efficient execution mechanisms. A query optimizer generates one or more query plans for each query, each of which may be a mechanism used to run a query.
 
Query optimization is the function of many relational database management systems. The query optimizer attempts to determine the most efficient way to execute a given query by considering the possible query plans.
 

nulife

New Member
A query optimizer generates one or more query nplans for each query, each of which may be a mechanism used to run a query.it is component that analayzes queries and determines efficient execution mechanisms.
 

Saravanan28

Yellow Belt
A query optimizer translates a query into a sequence of physical operators that can be directly carried out by the query execution engine. ... The goal of query optimization is to derive an efficient execution plan in terms of relevant performance measures, such as memory usage and query response time.
 
Top