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!

11g Partitioned based index on large partitioned table suggestion

Discussion in 'SQL PL/SQL' started by jrmtl, May 13, 2015.

  1. jrmtl

    jrmtl Active Member

    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    55
    Hello all,

    I am supposed to create a partitioned index on a timestamp field of an already partitioned large table ( 100gb )
    Since I am not to experienced on the best way to proceed for this particular index

    What is the recommended type of index based on anyone's experience?

    Thx
    JR
     
  2. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

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

    jrmtl Active Member

    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    55
    Thanks for your reply... and sorry for the lack of details.

    I would think it would be a local partitioned index as this is a datawarehouse and the documentation reads local as the recommended way.

    I will find out more on how I should tackle this and reply back...