Closed

Article on Oracle SQL Tuning

Write an article with the following:

1) Tune complex SQL ( 5 table joins at least). Million rows at least.

2) Show Explain plan - Screen Shots

3) Show table columns, PK/FK

4) Explain the "Explain Plan" - every line

5) Show how "explain plan" shows the sql issues

6) Show revised and efficient SQL

7) Show explain plan with processing time - before tuning and after tuning

8) Either through screen shot or otherwise show how SQL is processed by the database - align with explain plan. You can get this through tuning tools.

In your bid, please tell your experience and your strategy for this article. If you have real world experience, thats fine too. Just let me know and we will decide.

The article has to be in depth , describing and "explain plan" thoroughly that show how bad SQL was transformed into GOOD SQL- all components of Explain plan : Hash Join, Hints, Access methods, Selectivity, Joins need to be discussed in detail
------ Compare elapsed time of query with new plan to original. It should be at least 50% to 100% better than bad query
------ Multiple use cases should be fully explained to show the tuning concepts at advanced level
------- A draft template with subheadings should be provided by Freelancer and should be approved before start of work
------ All the scripts including the SQL, create table scripts, data should be returned to employer
------ The freelancer agrees to non- disclosure agreement by accepting this project. This article is “Confidential, Non-Competitive and Non Solicitation”. "The Confidential Information shall be kept in strict confidence by the Freelancer and shall not be used, without the Employer’s prior written consent, for any purpose other than in connection with the completion of the Project. "
-----The article belongs to Employer and cannot be used by freelancer in any shape or form.


Beceriler: Veri Tabanı Yönetimi, Veritabanı Geliştirme, Oracle, SQL

Daha fazlasını gör: excel, data entry, data processing, oracle, sql, database programming, database development, excel, data entry, data processing, oracle, sql, , write oracle sql query oracle 10g, write query displays employee number salary employees earn thant average salary oracle sql, display salary decimal oracle sql write query, write query top salary oracle sql, bid write article, write article interior design, phrases write article, paid write article posts, write article topic, write article look newspaper, write article newspaper english, oracle sql date statements, migration oracle sql 2005, decimal places oracle sql statement, oracle sql scripts mssql, write article paid, wil write article, oracle sql order numbers last

İşveren Hakkında:
( 33 değerlendirme ) Erie, United States

Proje NO: #15440961

Bu iş için 8 freelancer ortalamada $45 teklif veriyor

vinaysinghh

A proposal has not yet been provided

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(45 Değerlendirme)
5.2
hinahanif15

Greetings,  I am interested in doing this job. I am BS-CS graduate and knows Database programming as well, because of which I can do this task with ease. Have worked on Orcale, MS- Access and MySQL. Please do give me Daha Fazla

in %bids___i_period_sub_35% gün içinde60%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(12 Değerlendirme)
3.6
WhatTechnologies

A proposal has not yet been provided

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(3 Değerlendirme)
2.1
AntonBliznetc

Hello. i complete clear you db to fast and simple. if you not have money i can do free. not All free, only 1-2 idea and implemented. message my. thanks.

in %bids___i_period_sub_35% gün içinde106%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(6 Değerlendirme)
2.1
pratik123

Hi , I can do it for you. Connect me asap. Relevant Skills and Experience Pl/sql PT Proposed Milestones $20 USD - Sol1 $15 USD - Sol2

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
0.9
in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
Ashwin2017

I have 6 years of SQL development experience. I can author this article in a simple and lucid way. Relevant Skills and Experience SQL, SQL tuning Proposed Milestones $30 USD - Content Please connect with me for deta Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
niks1074

I will prepare the article with real time examples of sql tunning dealing with millions of data with its performance tuning and explain plan analysed in it. Relevant Skills and Experience plsql/4year Proposed Milesto Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0