| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Star Query Indexes
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?
 |
 |