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.