Query Optimization in Oracle 10g and MS SQL 2005

Paper Summary:

This paper considers Oracle 10g and MS SQL 2005 in relation to how they approach query optimization. Using essentially the language each company uses to describe its own products, the paper attempts to determine how the databases define a search space, estimate costs, determine an algorithm and construct a query plan. The paper concludes that both product take approaches are consistent with their target market.

From the Paper:

"Query Optimization is one of the most important features of a database, as it determines how quickly and accurately data is retrieved and at what cost to operating resources. It is a difficult problem for any database architect to solve and one of the first that must be considered as new products are built. This paper will consider the query optimization features of two leading databases: Oracle 10g and MS SQL 2005, also called Yukon. After providing a general view of what problems must be solved in query optimization strategies, and the general relevant features of the databases in question, the paper will compare the approaches taken by each of these products in their efforts to provide useful queries that don't tax users with undue decision-making burdens or long response times."

More papers on Query Optimization in Oracle 10g and MS SQL 2005:

• Analytical Essay # 126272 : "'In Cold Blood' and Capital Punishment"
• Essay # 50336 : "Oracle Bones and Traditional China"
• Research Paper # 91255 : "Just-in-Time Inventory and Quality Control"

APA Citation:

MLA Citation: