Answer: 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
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 Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
There should not be any Spelling Mistakes.
There should not be any Gramatical Errors.
Answers must not contain any bad words.
Answers should not be the repeat of same answer, already approved.