Execution plan on partition table
SQL:
select count(time_stamp) from e3suite.ees_fd_uva_hist partition (P11_12_2013)
Plan:
Description Object Owner Object name Cost Cardinality
SELECT STATEMENT, GOAL = ALL_ROWS 2293869 1
SORT AGGREGATE 1
PARTITION RANGE SINGLE 2293869 2131843750
PARTITION LIST ALL 2293869 2131843750
TABLE ACCESS FULL E3SUITE EES_FD_UVA_HIST 2293869 2131843750