Question: Write the 5 different queries from the same tables and rows. This can use different indexes, joins, aggregates, merges, parallel/serial, etc. Then force a better

Write the 5 different queries from the same tables and rows. This can use different indexes, joins, aggregates, merges, parallel/serial, etc. Then force a better query plan using hints

Here are the instructions:

-Create a database with some tables, insert some rows, and select 5 different queries.

-Save screenshots of the query plans generated by the optimizer for all 5 different queries.

-Run the queries and record the execution time.

-Add hints to the queries, and take screenshots of the new query plans.

-Run the queries with hints, and record the execution time.

-Show the impact of your hint by displaying the performance improvement. It can be calculated using the below formula:

-Percent Improvement = 100 * ( 1 - (optimized time / original time) )

-The bigger the improvement, the better.

-Tell us why the initial query plan was chosen by the query optimizer and what improvements you made, and the rationale behind your choices

Step by Step Solution

★★★★★

3.38 Rating (160 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Sure here is an example of 5 different queries on the same tables and rows using different indexes joins aggregates merges parallelserial and forcing ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...

Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...

What are the side effects of the drugs that are used for treatment of Multiple Sclerosis attacks? Are cataracts a result of steroid use? Is osteoporosis a complication of Multiple Sclerosis?

A long vertical wire carries an unknown current. Coaxial with the wire is a long, thin, cylindrical conducting surface that carries a current of 30 mA upward. The cylindrical surface has a radius of...

Make an assessment of the alternative competitive strategies that Bridgestone can pursue to strengthen its European market position (you can also include central and Eastern Europe).

Find the value of the constant c for which the function f defined by f (x) = c 2 + cos( x) ex3 , 0 x 2, 0, elsewhere, is a density function for a continuous random variable X. Using this value...

Recall from Exercise 10.1.11 that the data file HousePrices contains data on prices ($) and sizes (in square feet) for a random sample of houses that sold in the year 2006 in Arroyo Grande,...

how much is the total manufacturing cost per unit? Current Attempt in Progress Concord Company had the following department information for the month: Total materials costs Equivalent units of...

Donna Shader, manager of the Winter Park Hotel, is considering how to restructure the front desk to reach an optimum level of staff efficiency and guest service. At present, the hotel has five clerks...

You need to trace the route that a Cat 6 UTP cable takes through the ceiling and walls of your building. Which tool should you use

Pedro is an employee of a soft drink company. He has been working in the organization in the human capital area for 15 years. Recently, he began to reflect on how the human capital area has evolved...

You are on the coast of Long Island, facing south. Hurricane Jessica is moving north toward you and is expected to make landfall with a forward speed of 30 mi/hr. Which of the two scenarios below (a)...

Any help plz short-essay questions 1. Describe the socialization process of a new recruit. Why is this an important process for a new hire? 1. List of reasons as to why sales organization to train...

Question 9 (10 points) Innovative work behavior refers to an "everyday innovation" dependent on the employees' intentional demands. True False

we discussed material from the book "Scrum Mastery + Agile Leadership". Specifically, we discussed the "three platinum principles" upon which leadership in Agile is based. These principles include:...

\begin{tabular}{|cccc|} \hline \multicolumn{4}{|c|}{ Property Class } \\ \hline Year & Three-Year & Five-Year & Seven-Year \\ \hline 1 & 33.33% & 20.00% & 14.29% \\ 2 & 44.45 & 32.00 & 24.49 \\ 3 &...

What are some of the possible sources of information about a company that could be used for determining the companys competitive stance?

KEM Company has begun studying customer lifetime value for its customers and has prepared the information below for selected customers. For simplicity, management has assumed that for a given...

In a company that takes telephone orders from customers for general merchandise, explain how you would evaluate the performance of the company president, a middle manager who designs the system to...

What are three broad uses for budget information?

Describe theories of how prejudice is learned and how it can be overcome.

Describe the different types of love outlined in Sternbergs theory.

Identify factors involved in interpersonal attraction.