Reference no: EM131223143
Physical Database Design Assignment: Query Optimisation
This assignment aims to develop your skills optimizing query.
It involves identifying the suitable methods for structuring the data and writing the query.
First, you will need to create a query on some unstructured data. Unstructured data can be thought of in this context as a table which is NOT clustered or hashed. In addition the table should NOT contain any indexes at all. The query can be an equi-join or a sub-query.
The time a query with unstructured data takes to execute (execution time) will be used as the baseline.
Plan how to set up indexes, clusters, and hashed clusters for the same query. Use different numbers of rows and graph these for each type of structure. You need to create enough rows to indicate a trend in the performance (Number of rows should be enough).
You should then run the query and note the execution times for EACH of these structures.
Record the results. When doing this you could alter the way you set up some of these structures by, for instance, altering the hashkey or what you cluster together and note any differences in execution time.
You should by now have determined the optimal data structure in terms of performance. To be confident that your data will make things difficult for Oracle, ensure that:
- the data is as unordered as possible
- you retrieve a number of rows
You now have some choices about how you might improve the SQL statement. Take the best optimisation and try to improve it by inserting hints and swapping the order of the tables in the 'from' clause of your query.
The best of these 'improved' statements then needs to be tried out using Oracle's Parallel Query Option.
|
Show the impact on the federal reserves balance sheet
: Show the impact on the Federal Reserve's balance sheet of a foreign exchange market intervention where the Fed sells $1,000 worth of foreign exchange reserves.
|
|
Explain how the given event influence the bank
: Write a 2-page, double space 12 font essay. Introduce a current event and explain how this event influence the bank. Open topic.
|
|
Prepare new contribution format income statement
: Miller Company’s most recent contribution format income statement is shown below: Prepare a new contribution format income statement under each of the following conditions (consider each case independently):
|
|
Combinations of monetary and exchange rate policies
: Assuming the country is open to international capital flows, which of the given combinations of monetary and exchange-rate policies are viable?
|
|
Develop your skills optimizing query
: 406706 - Physical Database Design Assignment: Query Optimisation. This assignment aims to develop your skills optimizing query. It involves identifying the suitable methods for structuring the data and writing the query
|
|
Do you think happiness is connected to being a good person
: Aristotle seems to argue that happiness is only possible if you are a virtuous person. Aquinas, on the other hand, leaves happiness out of the universal human goods. Do you think happiness is connected to being a good person? If so, how? If not, w..
|
|
How it interprets the firms financial strength
: Review Ford Motor Company's Form 10-K for 2012. Explain the purpose of a company's 10-K and how it interprets the firm's financial strength.
|
|
Construct a program flowchart and corresponding pseudcode
: Construct a program flowchart and corresponding pseudcode that will compute and output the first number greater than 100 in the preceding series. No input is required.
|
|
Generate annually for purchase to be economically viable
: MARTA is considering purchasing a fleet of 20 solar powered mini buses. The anticipated purchase price of the fleet is $1,500,000 or $75,000 per bus. Each mini bus is expected to have a useful life of four years when it can be sold for $5000. Assumin..
|