Re: Star Query Indexes

mike_at_mrush.demon.co.uk (Mike Rushton) wrote:

>So far as i can see, it seems that Oracle's Star Query functionality is useless
>unless your fact table table has only a few keys, and you use ALL the keys in a
>query.
>If you have more than say, five key fields, it is unreasonable to create a
>concatenated index on all of them and also to expect users to always create
>query's based on values for all of those key fields.
 

>How have others implemented Data Mart Indexes?
 

>======================================================
>Mike Rushton | "A greate many open minds
>mike_at_mrush.demon.co.uk | should be closed for repairs"
>======================================================

Have you looked into bitmap indexes?

• Robert Gordon