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.
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.
Environment: Oracle 9i 126.96.36.199.1 Running on Windows 2000.