Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Star Join Query in Oracle 8

Star Join Query in Oracle 8

From: Clark Morrow <zzz.cemorrow_at_kodak.com>
Date: 1997/09/02
Message-ID: <01bcb7f3$4cda6b90$21d36796@kp-bridg-w08>#1/1

Has anyone tried the new star join in Oracle 8? Is it "dramatically faster?"

From the Oracle white papers, the new star join seems to rely on finding the records in the fact table before joining to the dimension tables. Yet, in star queries that constrain on dimension attributes, it is necessary to first query on the dimension tables to determine the keys to lookup in the fact table. Thus it would seem that the Oracle 8 star join can only be used on a limited subset of star joins. Received on Tue Sep 02 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US