Skip to Main Content

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!

Why query on partitioned table takes more time

518838Jun 6 2007 — edited Jun 11 2007
Hi,
I'm having a partitioned table, range partitioned on booking_date and having composite index on(link_id,booking_date,billing_indicator.....)
I'm running a query which takes values from one partition only(As per execution plan), & the index is also local partitioned index.
Table & index are analyzed.
The problem here is that the same query takes more time when its run on partitioned table. If I run the same query on non-partitioned table with same structure and data, its much faster.
Please advise me as to why the query is much slower on partitioned table while it should be faster.

Thanks
Deepak
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 9 2007
Added on Jun 6 2007
11 comments
1,568 views