Explan Plan :Every row in the Table Partitions accessed #97 - #120 is read
601989Jul 18 2009 — edited Jul 18 2009Hi,
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