[Mondrian] Does order of dimension in NECJ matter with regards to performance?

[Peter Tran]

Hi Zelaine,

Do we really delegate all these NECJ to the underlying RDBMS?  Are you
saying that we actually generate a SQL that joins across all those
dimensions?  That's not what I'm seeing when I turn on the trace to view
the actual SQL.

It looks like we do some of this filtering internally in memory within
Mondrian.

Am I wrong?

Thanks,
-Peter

-----Original Message-----
From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org]
On Behalf Of Zelaine Fong
Sent: Thursday, September 27, 2007 10:17 AM
To: Mondrian developer mailing list
Subject: Re: [Mondrian] Does order of dimension in NECJ matter with
regardsto performance?

It shouldn't, unless the underlying DBMS you're using has limitations in

how it optimizes join queries.

-- Zelaine

Peter Tran wrote:
> Hi,
> 
> If I have multiple dimensions nested within NECJ, does the order of
the
> dimension sets have any impact on performance?
> 
> For example:
> 
> NECJ(NECJ(NECJ(NECJ(dim1, dim2), dim3), dim4), dim5)
> 
> vs.
> 
> NECJ(NECJ(NECJ(NECJ(dim5, dim4), dim3), dim2), dim1)
> 
> Thanks,
> -Peter
> 
> 
> The information contained in this email may be confidential and/or
legally privileged. It has been sent for the sole use of the intended
recipient(s). If the reader of this message is not an intended
recipient, you are hereby notified that any unauthorized review, use,
disclosure, dissemination, distribution, or copying of this
communication, or any of its contents, is strictly prohibited. If you
have received this communication in error, please contact the sender by
reply email and destroy all copies of the original message. Thank you
> 
> 
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian

_______________________________________________
Mondrian mailing list
Mondrian at pentaho.org
http://lists.pentaho.org/mailman/listinfo/mondrian


The information contained in this email may be confidential and/or legally privileged. It has been sent for the sole use of the intended recipient(s). If the reader of this message is not an intended recipient, you are hereby notified that any unauthorized review, use, disclosure, dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please contact the sender by reply email and destroy all copies of the original message. Thank you