When we are going for Shortcut join and why.

Answer Posted / pvraobo@gmail.com

Shortcut join is a join that provides an alternative path between two tables.shortcut join improve the performance of a query by not taking into account intermediate tables.
Note:This is only used per improving the report performance.

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to generate the report from excel sheet?

586


Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.

3847


Can we create universe with no cache??

1958


What is difference between custom hierarchy and report based hierarchy?

551


How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

579






Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....

1491


any difficulitis have you phase while creating bo reports and how did u solve it

2996


what is xcelsius architecture?

3747


Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1432


Explain the difference between union and group?

632


Difference between b.o 5.1 and 6.1b?

653


what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?

9882


what is document design in boxi,have u participate in that

1663


Explain how to execute the plsql procedure from the report by clicking with mouse?

600


If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?

557