ganesh.hbad

 Profile Answers by ganesh.hbad 

• Apr 17th, 2008

 

short cut joins are used to improve the query performance at universe level.
Suppose if we have 4 tables A,B,C and D

A--->B---->C---->D and  there is a chance to link A--->D  but we should not link (causes loop) and we need data from the tables A and D then it will get the data in the path A--->B---->C---->D , it consumes lot of time and resources.

In this case instead of linking A---->D using normal join we should link A and D by using short cut join and this will not create any loop and get the data in the path 
 A--->D, it consumes less time and resources.

anuanu

 Profile Answers by anuanu 

• May 12th, 2008

 

As per my knowledge shortcut join will resolve the loop automatically.