Scholars Central

CommentaryPublished 20 Jan 2021

Analysis of Query Optimizers

Authors: Ramineni Sharath Kumar

Ask about this article

Abstract

Select any words in the title or abstract, or press this and choose a sentence.

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 The query optimizer attempts to determine the most efficient way to execute a given query by considering the possible query plans. Importance: The goal of query optimization is to reduce the system resources required to fulfill a query, and ultimately provide the user with the correct result set faster. This is a feature of many relational database management systems and other databases such as graph databases.

Ask about this article

Answers come only from this article's title, abstract and keywords, each sentence pointing to where it comes from. Your question is sent to OpenAI to write the answer. Scholars Central does not store it.

Try:

Similar by topic

More from this journal

The newest in Journal of Computer Engineering & Information Technology.

All its articles

Conferences in this field

Upcoming conferences in this field.

Follow

New articles from what you follow go into your email digest, once you agree to alert emails.

  • JournalJournal of Computer Engineering & Information Technology
  • SubjectComputer Science & IT
  • SubjectEngineering
  • BylineArticles whose byline prints “Ramineni Sharath Kumar”

For authors and organisers

Publish, present and keep up with your field

Find the right journal for your paper and submit your manuscript.

Photo: Pexels