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.


Skills: Database Administration, Database Development, Oracle, SQL

See more: 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, samples write article news paper, paid write article, oracle sql server postgres mysql comparison, place write article, oracle sql age date

About the Employer:
( 33 reviews ) Erie, United States

Project ID: #15440961

8 freelancers are bidding on average $45 for this job

vinaysinghh

A proposal has not yet been provided

$55 USD in 1 day
(45 Reviews)
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 More

$60 USD in 3 days
(12 Reviews)
3.6
WhatTechnologies

A proposal has not yet been provided

$20 USD in 1 day
(3 Reviews)
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.

$106 USD in 3 days
(6 Reviews)
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

$35 USD in 1 day
(1 Review)
0.9
$30 USD in 3 days
(0 Reviews)
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 More

$30 USD in 1 day
(0 Reviews)
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 More

$25 USD in 1 day
(0 Reviews)
0.0