By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,456 Members | 1,742 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,456 IT Pros & Developers. It's quick & easy.

Star Transform condition?

P: n/a
Can someone please clear up some confusion I am having on Star
Transformations: I have read about the conditions for Star
Transformations, especially this onen (from 9i Data Warehousing
Guide):

"A prerequisite of the star transformation is that there be a
single-column bitmap index on every join column of the fact table.
These join columns include all foreign key columns"

Does this mean every join column in a particular query, or every Fact
record FK column in the table ?

I have a single col bitmap index on all but one of my FK columns in a
fact table; the column in question is the primary key and links to a
"Descriptive" Dimension - one record per Fact. Since this column is the
PK I have a PK constraint on it...and therefore cannot have a Bitmap
Index in addition. I have Star_Transformation option enabled, I'm
using the CBO but still not getting a Star Query Plan.

Reading the documentation, I would have thought that if this column is
not used in a query I would get a Star Query Plan, but when it was
used I would not.

Thanks

Jeremy
Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.