Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership

Categories

Tagged

Mailing list users (luciddb-users) can "claim" their threads in the archives by registering with the same account they used to post to the email list. NOTE: List threads are updated once every 24hrs.
Index in star schema
  • haubuchon January 24
    Do we need to create indexes for tha table in a typical star schema to achieve high performance ?
    If yes, what indexes are needed ? On surrogate keys in the fact table ? members in the dimension tables ?

    Thnaks !

  • nagoodmannagoodman March 15
    Yes you should index columns to provide LucidDB the opportunity to use it's STAR join optimizations.

    Usually it's a matter of indexing the surrogates in the FACT (dimension ids), and the IDs in the dimensions (usually a PK anyhow).  That is USUALLY all that's needed because dimensions tend to be small.  *if* you have particularly large dimensions (ie, >1million rows as a rule of thumb) it's best to also index level columns there.

    Hope that helps!  Sorry for delay, btw.  Missed this one in the forums.
Add a Comment