Hi,

Oracle 81730/NT.

I just converted one non-partitioned table into range based partitioned one with effective_date as partitioned column.

Now, I am running foll. query.

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

Explain Plan
---------------
SELECT STATEMENT (RULE)
PARTITION RANGE ITERATOR
TABLE ACCESS FULL GL_JE_LINES (Analyzed)


What is the meaning of PARTITION RANGE ITERATOR?

Does it use the partition or full table?

Thanks in Adv.