hi everybody,
I have two choice, I can use alias or shortcut join.
I wonder that, Is there any performance difference between them?? which one will be the best solution.
thanks…
bz.ilyasoglu (BOB member since 2010-11-10)
hi everybody,
I have two choice, I can use alias or shortcut join.
I wonder that, Is there any performance difference between them?? which one will be the best solution.
thanks…
bz.ilyasoglu (BOB member since 2010-11-10)
Welcome to B:bob:B!
Please go through this sticky topic where using aliases and/or contexts in a universe is discussed:
Marek Chladny (BOB member since 2003-11-27)
Shortcut joins are not a substitute for aliases or contexts. Make your universe work first. Then consider adding shortcuts for performance reasons. The topic linked previously does a nice job of discussing the differences between aliases and contexts for loops, but it does not really cover shortcuts because they’re not equivalent.
I wrote a somewhat lengthy blog post on shortcuts that contains a lot more information than I want to repeat here (which is why I wrote it to begin with).
Dave Rathbun (BOB member since 2002-06-06)
think about that, for example I have a table and it is the left farest leaf of our fact table and other is the right leaf of our fact table, I can join these two with shortcut or instead of this I can create an alias table of left table and join these two.
I wonder that which one will show the best performance??
thanx…
bz.ilyasoglu (BOB member since 2010-11-10)