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

Zelaine Fong zfong at lucidera.com
Thu Sep 27 11:17:15 EDT 2007


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




More information about the Mondrian mailing list