Kapalı

Write some oracle Software

You will need to start by creating 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 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. The number of rows should be significant enough to indicate a trend in performance.

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 hash key 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.

Don't overlook explanations of what's happening. Just handing in a listing of a TRACE without saying what it all means will leave the marker feeling ignored and incapable of awarding marks. An accurate brief comment on each event is as important as the experiment itself.

The last section of your submission will consist of a short reflective report (max length: 300 words) that discusses the effectiveness of Oracle’s query optimizer.

Beceriler: Oracle, PHP, Yazılım Mimarisi

Daha fazlasını görün: use type graph, record data structure, graph use data, type data structures, structure graph, sql comment oracle, set data structures, set data structure, oracle sql comment, max graph, key data structure, write report event, write performance report, hash tables data structures, hash table data structure, hash data structures, hash data structure, handing out, graph structures, graph structure, graph data structure using, graph data type, graph data structures, execution table, different type data structure

İşveren Hakkında:
( 3 değerlendirme ) Auckland, New Zealand

Proje NO: #6535915

6 freelancer bu iş için ortalamada 183$ teklif veriyor

letshappy

hello, i am red hat certified engineer and i easily can do this task i am more then 4 yer experience in this field ready to start now thanks

in 3 gün içinde221$ NZD
(10 Değerlendirme)
4.7
maulikvirani87

Hi, We have gone through the requirements posted by you and firmly believe that our company will be able to provide great solution along with ideas for your project. Kindly share your Contact Details and let us arr Daha fazlası

in 3 gün içinde166$ NZD
(1 Değerlendirme)
1.5
toash08

A proposal has not yet been provided

in 3 gün içinde155$ NZD
(0 Değerlendirme)
0.0
naveenreddy54

Hi I am very good in building the oracle queries and finishing the projects in time. I understand the proposed project and I am very much interested to work along with you. Please send the further details and let me kn Daha fazlası

in 3 gün içinde155$ NZD
(0 Değerlendirme)
0.0
dhavallodha

I am having 10+ Years experience in Oracle Database as Oracle Database Consultant, Performance Tuning, Data Modeling, PL/SQL Developer, Data Architect, Database Administrator. I am Oracle Certified Profession (OCP).

in 3 gün içinde200$ NZD
(0 Değerlendirme)
0.0
abhinovpankaj

Hi, We are a team of working as software professional in IT industry from last 4 years. Working as DBA and maintenance of various DBs deployed on Oracle 11G Thanks Abhinov

in 4 gün içinde200$ NZD
(0 Değerlendirme)
0.0