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

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