Hi Orca,

In the plan table, it shows 'KEY' in start and stop-pertiition id. Foll. is the E.P.

Execution Plan
----------------------------------------------------------
0 SELECT STATEMENT Optimizer=RULE (Cost=2324 Card=5602 Bytes=3
9214)

1 0 PARTITION RANGE (ITERATOR)
2 1 TABLE ACCESS (FULL) OF 'GL_JE_LINES' (Cost=2324 Card=560
2 Bytes=39214)

and Foll. is the partition info.

partition by range (effective_date)
(partition gl_je_lines_p0 values less than (to_date('01-JUL-2001','DD-MON-YYYY')),
partition gl_je_lines_p1 values less than (to_date('01-SEP-2001','DD-MON-YYYY')),
partition gl_je_lines_p2 values less than (to_date('01-DEC-2001','DD-MON-YYYY')),
partition gl_je_lines_p3 values less than (to_date('01-APR-2002','DD-MON-YYYY')),
partition gl_je_lines_p4 values less than (to_date('01-JUL-2002','DD-MON-YYYY')))


Thanks,