Oracle Database Discussions

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!

cost in explain plan vs elapsed time

573141May 6 2010 — edited May 7 2010

hi gurus,

i have two tables with identical data volume(same database/schema/tablespace) and the only difference between these two is, one partitioned on a date filed.

statistics are up to date.

same query is executed against both tables, no partition pruning involved.

select ....... from non-partitioned
execution plan cost=92
elapsed time=117612

select ... from partitioned
execution plan cost=3606
elapsed time=19559

though plan cost of query against non-partitioned is quite less than partitioned, elapsed time in v$sqlarea is higher than partitioned.

what could be the reason please?

thanks,
charles

Edited by: user570138 on May 6, 2010 6:54 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 4 2010

Added on May 6 2010

#general-database-discussions

10 comments

9,946 views