What is query optimization?

What is query optimization?

What is query optimization?

View Answers

November 19, 2010 at 11:47 AM

Hi,

Here is the answer,

Sql Statements are used to retrieve data from the database. We can get same results by writing different sql queries. But use of the best query is important when performance is considered. So you need to sql query tuning based on the requirement. The query optimizer is the component of a database management system that attempts to determine the most efficient way to execute a query. The optimizer considers the possible query plans for a given input query, and attempts to determine which of those plans will be the most efficient.There are so many optimization techniques following steps are used to select best plans-

-Consider each possible plan in turn.

-Run it & measure performance.

-The one that was fastest is the keeper.









Related Tutorials/Questions & Answers:
ModuleNotFoundError: No module named 'djangorestframework-serializer-query-optimizations'
What is the Sub-Query?And what is the properties of Sub-Query?
Advertisements
What is query optimization?
What is Hibernate Query Language (HQL)?
ModuleNotFoundError: No module named 'nonlinear-optimizations'
ModuleNotFoundError: No module named 'nonlinear-optimizations'
ModuleNotFoundError: No module named 'django-optimizations'
ModuleNotFoundError: No module named 'emzed_optimizations'
query
query in JDBC
database Query
database Query
Query on java - Ajax
Query conversion
query optimization
query string
What is Intersect?
Query Question
HQL Query
Sql Query
Sql Query
jdbc query
What is Correlated Subquery ?
sql query
session into a query
What is a "join"?
steps required to execute a query in JDBC
query problem
HQL query
SQL Query
What is RDBMS?
What is View?
Hibernate SQL Query/Native Query
query string
need query
DATABASE QUERY
Hibernate Query Language (HQL)
sql query
sql query
sql query
Sql Query
select query
SQL QUERY
Query in jsp
dynamic query
Query
query
query
Query
query

Ads