Database DataWarehousing (MOSC)

MOSC Banner

Best Access path to for aggregate query on a partitioned table

edited Nov 30, 2010 7:53PM in Database DataWarehousing (MOSC) 2 commentsAnswered
 Hi,
I have a following query based upon the partitioned table galaxy.SUBSCR_DETAIL_FACT( partitioned on SUBSCR_TYPE_STATUS_KEY)  :

  SELECT   F.PRIM_PRODUCT_KEY AS PRIM_PRODUCT_KEY,
           F.PRIM_PROD_ORG_START_DT_KEY AS PRIM_PROD_ORG_START_DT_KEY,
           F.PRIM_PROD_START_DT_KEY AS PRIM_PROD_START_DT_KEY,
           F.PRIM_PROD_END_DT_KEY AS PRIM_PROD_END_DT_KEY,
           F.PRIM_PROD_BIND_START_DT_KEY AS PRIM_PROD_BIND_START_DT_KEY,
           F.PRIM_PROD_BIND_END_DT_KEY AS PRIM_PROD_BIND_END_DT_KEY,
           F.SUBSCR_TYPE_STATUS_KEY AS SUBSCR_TYPE_STATUS_KEY,

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