471,050 Members | 1,350 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,050 software developers and data experts.

Star Transform condition?

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
0 2162

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by Safalra | last post: by
1 post views Thread by Jon Davis | last post: by
3 posts views Thread by gwise | last post: by
reply views Thread by MohF1 | last post: by
5 posts views Thread by gubbachchi | last post: by
reply views Thread by Jeremy Posner | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.