Show Bid Request Need a complex Oracle SQL query tuned Bid Request Id: 26249 Bookmark in my 'To Do' list Posted by: JTIDev (5 ratings) (Software buyer rating 9.8) Non-action Ratio: Above Average - 25.00% Buyer Security Verifications: Excellent Approved on: Sep 3, 2002 6:55:37 PM EDT Bidding Closes: Sep 6, 2002 7:07:46 PM EDT Viewed (by coders): 337 times Deadline: 9/13/2002 TIME EXPIRED Phase: 100% of work completed and accepted. Coder has been paid. Max Accepted Bid: Bidding is closed Project Type: Very Small Business Project: under $100 (USD) Bidding Type: Open Auction Categories: Database Enter chat room for this bid request (0 active users at Jul 10, 2003 11:27:29 AM EDT) Description: I have an extremely complex Oracle Select SQL query. I need some help to tune the query so that it can run in a reasonable time. The select query and a reasonable ER diagram will be provided after I accept your bid. You will not need to run the query yourself. You will need to communicate the optimizer hints or any other improvements you may deem necessary. The project may require a couple of phone calls, just to explain the schema. It can be done by email as well. You must be exceptionally good in tuning area to have a go at this project. I realize that it is possible that this is an unsolvable case (Though I highly doubt that). If we run into a situation like that, I will reimburse you $25 for your *sincere* and *reasonable* efforts. Deliverables: Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased. Platform: Environment: Oracle 9i 9.0.1.2.1 Running on Windows 2000. Must be 100% finished and received by buyer on: Sep 13, 2002 EDT Deadline legal notes: All times are expressed in the time zone of the site EDT (UT - 5). If the buyer omitted a time, then the deadline is 11:59:59 PM EDT on the indicated date. Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements. We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thanks for your help.   Bidding/Comments: All monetary amounts on the site are in United States dollars. Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests. See all rejected bids (and all comments) Name   Bid Amount    Date   Coder Rating   This bid was accepted by the buyer! OraDev (5 ratings) in Wilmington, Massachusetts United States Bid id: 298,750 This coder is certified! Click here for transcript   $50 (USD) Sep 4, 2002 5:05:26 PM EDT  9.6 (Excellent)     Hi, I believe I have the expertise to complete your request. I am certified to write SQL queries through both ExpertRating and Oracle, and I have been working with SQL for over 10 years now, particularly with regard to performance tuning of queries. I look forward to hearing from you. -OraDev           See 6 private reply(ies) to/from OraDev.