Re: Star Query Indexes
From: Mike Rushton <mike_at_mrush.demon.co.uk>
Date: 1996/11/08
Message-ID: <32826194.5330581_at_news.demon.co.uk>#1/1
Mike Rushton | "A greate many open minds mike_at_mrush.demon.co.uk | should be closed for repairs"
Received on Fri Nov 08 1996 - 00:00:00 CET
Date: 1996/11/08
Message-ID: <32826194.5330581_at_news.demon.co.uk>#1/1
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"
Received on Fri Nov 08 1996 - 00:00:00 CET