Re: Star joins?
Timour, you got it.
I don't have any readily reproducable examples for you, and performance is fine in the one DB I have with a cleanly structured star schema, but it has only 3 million rows and a half dozen dimension. Kimball's Data Warehousing Toolkit could be a good source of scenarios and examples that any product would want to address.
Thanks,
Seth
Subject
Views
Written By
Posted
3517
January 17, 2006 08:57PM
2637
January 18, 2006 10:39PM
2525
January 18, 2006 10:41PM
2497
January 20, 2006 03:08PM
2611
January 20, 2006 06:42PM
2466
January 21, 2006 07:32PM
2501
January 22, 2006 03:22PM
3593
January 23, 2006 04:10PM
2540
December 09, 2006 06:25AM
5033
June 28, 2007 04:23AM
Re: Star joins?
2510
January 26, 2006 11:35AM
2623
January 26, 2006 01:00PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.