Database Administration (MOSC)

MOSC Banner

Execution plan on partition table

edited Dec 4, 2013 5:00PM in Database Administration (MOSC) 2 commentsAnswered
When I run an execution plan on an empty partition it takes several minutes to run and then I get the plan below. Is this plan indicating that it’s doing a full table scan on just the partition involved?

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 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center