DB2 LUW Indexes: B-Tree Details, Physical Storage and More

You may also like...

3 Responses

  1. S Amin says:

    When creating indexes for a star-schema is it beneficial for the natural key index to have the surrogate key as the second column? Since the lookups are done on the natural key usually, would having the surrogate key help with join efficient to the FACT table?

    • Ember Crooks says:

      Indexing in data warehouses is not my area of expertise, sorry. Pavan over at db2talk.com might be a better person to ask or know who would be better to ask.

  1. August 25, 2016

    […] DB2 LUW Indexes: B-Tree Details, Physical Storage and More […]

Leave a Reply

Your email address will not be published. Required fields are marked *