Skip to Main Content

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!

Explan Plan :Every row in the Table Partitions accessed #97 - #120 is read

601989Jul 18 2009 — edited Jul 18 2009
Hi,

I have aTable which has 20 partitons on date (From Feb 1 to 20).

I have inserted rows for the partioned date '04-02-2009'.

Then when I am retrieving data for the date '04-02-2009' the Explan plan returns :

"Every row in the Table Partitions accessed #97 - #120 is read"

Kindly anyone help me to figure out whether that particular partiotned date is accessed while storing and fetching the data?

N.B:I have already Analyzed the Partioned Table

Any help will be needful for me
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 15 2009
Added on Jul 18 2009
1 comment
676 views