Best Access path to for aggregate query on a partitioned table
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,
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,
0