My Suggestion What Is Meant By Query Optimization?

sinGN

White Belt
It attempts to determine the most efficient way to execute a given query by considering the possible query plans.
 

Theomax

White Belt
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.
 

Alberto Costa

White Belt
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.
 
Top