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