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?
No Answer is Posted For this Question
Be the First to Post Answer
What is object stores?
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
What is Cartesian product?
disadvantages of boxi
How many universes can be created in a project?
Say, the query gets executed and we got the results. In case if we have a large number of rows, how can we know the exact no of rows returned?
HOW TO SPOT A HIERARCHY?
what are the differences between web intelligence reports and crystal reports ?
Is it necessary to give joins to the aggrigate tables in the universe?
WHAT IS ROW LEVEL SECURITY IN BO?
what is maximum scope of analysis --> can we define more than 3 levels?
Which one will be more preferable creating Derived table or Views on universe level.and Explain why also ?