Traditional Query Optimizers And Some Of Its Common Shortfalls Article

	1888 Articles Home \| Computer Articles \| Graphics Design Articles	Computer RSS
Traditional Query Optimizers and some of its common shortfalls

A query optimizer is a core component of any Database Management System and hence an important ingredient in custom software programming. A query optimizer attempts to determine the best ways to implement a query.

Author: Manish

Article Tools:

In custom software programming , it is difficult for developers to determine the most efficient query plans. Query optimizers test all query plans of a given input query and tries to determine which of these plans is the most efficient. To determine the cost of each possible query plans, cost-based query optimizers are used. They are used to estimate the runtime costs of evaluating a query.

Most query optimizers represent query plans as “plan nodes” arranged as a tree, where the intermediate results flow from the bottom to the top of the tree. Each node comprises of child nodes. Users cannot access query optimizers directly, the queries are sent to the database server, parsed by the parser and then submitted to the query optimizer for successful optimization.

Disadvantages of Traditional Query Optimizers in Computer Software Development
Query optimization has always been an interesting and difficult problem for custom software development services . Traditional approaches of query optimizers such as statistical and cost-based do not provide desired results. They have some problems which need to be sorted out.

A traditional query optimizer may select a bad query plan. Moreover, query plans change in production and provide negative results. This can be quiet a frustration for the software developer engaged in the development of software . Traditional cost based query optimizers make life difficult for computer software development experts due to the unpredictability of the query plan selection.

Nowadays, programmers dabble with modern query optimizers that are not cost-based. Developers just have to try different plans and learn which ones work well. Developers also execute multiple query plans in parallel. Trying different plans ensures that the system does not try a bad plan. Modern query optimizers, thus, facilitate in development of software to a great extent.

About Author

I am the webmaster at www.synapseindia.com – A web development company offering affordable web promotion to businesses in India and abroad.

Article Source: http://www.1888articles.com/author-manish-20409.html

Traditional Query Optimizers and some of its common shortfalls