pinki

• Jul 20th, 2006

 

short cut join joins the two tables which r already in a path.SCJ skips the intermmediate tables and joins the table which are already in the common path,

 using SCJ increases thge performance of the query bcoz the no of tables in the query decreases that means the retreival of the data is more faster rather than before.

for instance if we have customer,orders,order_line classes and cust id object is there in three classes and customer is joined to order_line through orders n we want the information only from customer n order_line then create a SCJ BETWEEN CUSTOMER N ORDER_LINES SKIPPING THE INTERMMEDIATE TABLE ORDERS

ravi_kumar_garre

 Profile Answers by ravi_kumar_garre 

• Nov 20th, 2007

 

Shortcut join allows to define an alternative, faster join path between two tables. without the use of a shortcut join, query would have to go through a huge fact table to create simple reference lists.

Cheers,

Ravi Kumar Garre

ASHOK1324

 Profile Answers by ASHOK1324 

• Apr 19th, 2009

 

A. short cut joins are used to improve the query performance at universe level i.e. for performance tuning.

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.

sreenu

• Jul 2nd, 2014

 

shortcut join is a join , It is an alternative path between the tables .
By using shortcut join we can improve the performance of query and decrease the join path.