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
How to generate the report from excel sheet?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
Can we create universe with no cache??
What is difference between custom hierarchy and report based hierarchy?
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)?
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....
any difficulitis have you phase while creating bo reports and how did u solve it
what is xcelsius architecture?
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
Explain the difference between union and group?
Difference between b.o 5.1 and 6.1b?
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?
what is document design in boxi,have u participate in that
Explain how to execute the plsql procedure from the report by clicking with mouse?
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?