1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Partiton on fact table and index on it

Discussion in 'SQL PL/SQL' started by ashish kumar, Jul 29, 2014.

  1. ashish kumar

    ashish kumar Active Member

    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    80
    Hi ,
    I have one fact table with 10 milions records with five different customer.
    Column customer_id in fact table have five different values.
    There are around 6 dimension table that have 20k records around each.
    Each dimension key is primary key in dimension and foreign key in fact table.

    my data warehouse query taking too much time.

    I have to partition fact table by customer_id as list partition and sub partition Querterly as range partition.

    Please suggest me which colums need to be indexed and what type(b tree otr bimap)


    Index shouls be created or not on partiton key like cutomer_id and Querterly.



    Thanks,
    Ashish
     
  2. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    626
    Likes Received:
    129
    Trophy Points:
    810
    Location:
    Russian Federation