Partitioned table details in the Explain Plan

[Rathi Rao]

Hi,

I have a partitioned table. And the partition is based on the values 1 and 0. So, it's 2 partitions..

select * from farmer where partitionflag = 1

When I see the plan,

1 SIMPLE farmer ALL 102103 Using where

The 'type' column says, 'ALL'.. This is what I do not understand.. Is it okay? Since, it's partitioned, would there be anything in the plan that would indicate that the desired partition is accessed?

Also, is there a necessity to again create a index on it or that partitioning itself is enough?

Any explanation on this would be of great help..

Thanks in advance
Rathi