Not using Partition in Explain plan

[samdba]

Hi Calvin_Qiu,

Based on my query

select * from gl_je_lines
where effective_date >= to_date('01-JAN-2001')
and effective_date < to_date('31-JAN-2001')

It should not use all the partitions as this range of data will be in only one partition.

Thanks,