SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle Optimization [Parallel Hints]

614360Feb 25 2008 — edited Feb 25 2008

Hi All,

I am using Oracle queries for the development of BI publisher reports. I wrote required sql logic for the report. Now I want to optimize the oracle SQL. I am using PARALLEL HINTS for the same. The sql which costs around 30-35 before applying PARALLEL HINTS is giving me the cost 20-25 after applying HINTS. I used 5-6 tables which has data around 1000-1500 rows. Up till this everything is ok.

Now the problem is: I added that optimized sql into xdo to run the report and clicked on VIEW to see the output. The report is taking too much time to show the data (1 min). on the other side if I replaced that optimized sql with non-optimized sql, report is running faster (30 seconds) than the earlier one.

I am confused. If the cost is coming less for optimized query then why report output is taking longer time than the non-optimized query !!!!!

Any idea, why this is happening?

Thanks,
Amit D.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 24 2008

Added on Feb 25 2008

3 comments

690 views