Skip to Content
0
Former Member
Nov 22, 2011 at 12:10 PM

one or more infocube

11 Views

hello,

i got this questiom

I want to know about perfomance... what is better?

Lets think this scenario: if I have a query which want to compare data 2009 and 2010 (lets imagine they have more and less same records (forget about aggregate)

which is the best way?

a) MB : Infocube 2008 + Infocube 2009 + Infocube 2010

or

b) MB: Infocube 2008 + Infocube (2009+2010) //

the option b) its best way to select to database? because its just doing one select .. else a) two selects.

so, which would be the best approach a) or b) and why?

thx