13 Replies Latest reply: Feb 27, 2014 3:15 AM by Fabrice Aunez RSS

    Composite key performence issue

    sasi k

      HI all,

      I have 2 fact tables DAILY , SUMMARY (month wise)  andDimensions ,

      now i need to create a link table by creating a composite key, i have 7 DIMs so 7 key fields are there,

      now i have created a composite key with 7 keys fields ,


      Now my question : is there any effect on performence if i create a composite key with 7 key fields?

      if then please let me know what are they