176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Oracle SQL optimisation
Sign in to Add to Watch List

IT & Programming > Database Development

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

Feb 24, 2012
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Thu, Feb 23, 2012
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

I have a piece of Oracle code that takes 10 hours to run. I would like someone to optimise it so that it can run 5 times faster. You will have to create some sample data yourself.

I am open to having it re-written in PL/SQL.

However, please note I am working off around 50 million records so the volumes are large.

So, you need to create some sample data, then test the script that I have provided. (Time it etc). Then optimise it and compare its performance to the performance of my script. Of course, the outputs have to be the same.

A

Sign in or Register to see more

Job ID: 28862443
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

Jordan M.      
Jordan M.'s identity has been verified.  Learn More
 United States  |  
Over 18 years of experience, focusing in: Database Design Patterns - OLTP and DSS Data and Network Security Oracle Database RAC (design,...
2
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 29129875  |  Submitted: Mar 7, 2012 23:11 ET 
Proposal SEALED

Muhammad Nadeem      
Muhammad Nadeem's identity has been verified.  Learn More
 Pakistan  |  
Over the last 10 years, I have developed a wide range of software applications using Oracle Forms and Reports Developer including Inventory,...
1
  |  
 0.0   |  $0 Earnings   |  2 Jobs
Bid ID: 29121771  |  Submitted: Mar 7, 2012 13:37 ET 
Proposal SEALED

 United States  |  
I am an IT professional with 30 years of experience. I am an expert in Oracle Applications, Oracle database, and Oracle PL/SQL. I am proficient...
2
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 29096481  |  Submitted: Mar 6, 2012 11:54 ET 
Proposal SEALED

 India  |  
Have skill in COBOL, Oracle, Oracle PL/SQL, Oracle Forms & report, SQL Server 2005, DELPHI,Visual Basic, UNIX, Software Testing. Over the last...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 29063149  |  Submitted: Mar 5, 2012 06:08 ET 
Proposal SEALED

 India  |  
TISYA is run with a passion to provide solutions that enhance value to our customers. With years of experience in engineering and performance...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 28946694  |  Submitted: Feb 28, 2012 05:12 ET 
Proposal SEALED

 Pakistan  |  
99 Consulting is a Information Technology (IT) Services Company and mainly deals in ERPs / CRMs Implementation and Support, Business Intelligence,...
1
  |  
 0.0   |  Private   |  2 Jobs
Bid ID: 28921721  |  Submitted: Feb 27, 2012 03:29 ET 
Proposal SEALED

 Romania  |  
I am a senior Java programmer with an interest on performance.
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 28911778  |  Submitted: Feb 26, 2012 13:00 ET 
Proposal SEALED

Jay Norton      
Jay Norton's identity has been verified.  Learn More
 United States  |  
Oracle Database Versions 7 through 11g, Installation, SQL, PL/SQL, Database Tuning, SQL Tuning, Partitioning, Real Application Clusters (RAC),...
7
  |  
 5.0   |  Private   |  8 Jobs
Bid ID: 28909706  |  Submitted: Feb 26, 2012 10:01 ET 
Proposal SEALED

 United States  |  
I am a bachelors in computer who has worked on many mission critical projects with extremely high performance demands and very large amount of data...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 28907515  |  Submitted: Feb 26, 2012 05:51 ET 
Proposal SEALED

 United States  |  
IIT Kanpur graduate with 10+ years of experience in IT, with stellar track record. 6+ years in US for Compaq/HP Tech lead with hands on for 6+...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 28900774  |  Submitted: Feb 25, 2012 14:36 ET 
Proposal SEALED

Serhii Berezovych      
Serhii Berezovych's identity has been verified.  Learn More
 Ukraine  |  
6 years programming experience Skills: Oracle, MySQL, C++, PHP, JavaScript (jQuery AJAX)
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 28888848  |  Submitted: Feb 24, 2012 18:10 ET 
Proposal SEALED

 Romania  |  
Highly experienced in "Internet Research" , "Data Entry" and "Finding contact's details" and thrive for customer satisfaction. Possess good...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 28881168  |  Submitted: Feb 24, 2012 10:04 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »