Generate Vs. CrossJoin

#1

Hi,

Is there a difference, in terms of performance, between CrossJoin and
Generate, when getting the cross-product of two sets?

CrossJoin([Set1], [Set2])

Vs.

Generate([Set1], CrossJoin({[Set1].Current}, [Set2]), ALL)

Thanks.

John.

#2

Yes.

Why take the overhead of unioning the generate results when a simple cross
product is sufficient?

--
_______________
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.

"John" <nospam> wrote

Quote:

Hi,

Is there a difference, in terms of performance, between CrossJoin and
Generate, when getting the cross-product of two sets?

CrossJoin([Set1], [Set2])

Vs.

Generate([Set1], CrossJoin({[Set1].Current}, [Set2]), ALL)

Thanks.

John.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Generate Vs. CrossJoin

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Generate Vs. CrossJoin - 03-25-2005 , 09:16 AM

Re: Generate Vs. CrossJoin - 04-04-2005 , 01:08 PM