Welcome to WebmasterServe!

FREE TO JOIN! Join us now to engage in informative and friendly discussions about Webmastering, SEO, SEM, Internet Marketing, Programming, Graphic Design, Online Jobs and more. What are you waiting for? Ready to join our friendly community? It takes just one minute to register.

Dismiss Notice

Join WebmasterServe Forums 
Join the discussion! Have a better idea or an opinion? It takes just one minute to register Click Here to Join

My Suggestion What Is Meant By Query Optimization?

Discussion in 'Database Management' started by johnsmith123, Mar 18, 2017.

  1. johnsmith123

    Yellow Belt

    Joined:
    Dec 29, 2016
    Messages:
    136
    Ratings:
    +9 / -0
  2. sinGN

    White Belt

    Joined:
    Mar 12, 2017
    Messages:
    100
    Ratings:
    +1 / -0
    It attempts to determine the most efficient way to execute a given query by considering the possible query plans.
     
  3. Johngalvin007

    White Belt

    Joined:
    Mar 19, 2017
    Messages:
    10
    Ratings:
    +0 / -0
    A query optimizer generates one or more query plans for each query, each of which may be a mechanism used to run a query.
     
  4. Theomax

    White Belt

    Joined:
    Jun 20, 2017
    Messages:
    21
    Ratings:
    +1 / -0
    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.
     
  5. Alberto Costa

    White Belt

    Joined:
    Jan 13, 2016
    Messages:
    15
    Ratings:
    +0 / -0
    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.
     
  6. nulife

    nulife New Member

    Joined:
    Feb 16, 2016
    Messages:
    2
    Ratings:
    +0 / -0
    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.
     

Share This Page