HI, Can any body explain me ? If we careate objects using
derived tables it will decreasess the performence? If we
are not creating the objects using the derived tables then
what is the use of having the derived tables?

Answer Posted / padmalatha0923

we can create objects using derived tables
if derived tables increses then only performance decreses
but if we include one object form this table the entire query from this table is executed.we can see this in query panel

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the data types present in bo? What happens if we implement view in the designer and report?

614


how to create metric universe ?

1893


Explain what are the measure objects?

544


What is the difference between slice and dice and cross tab report?

599


What would you consider as your biggest achievement and why?

612






How to generate the report from excel sheet?

580


Explain is it the job of a business analyst or systems analyst to draw the class diagram?

585


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

1825


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

1659


What is difference between custom hierarchy and report based hierarchy?

547


What is the difference between absolute and relative div positioning?

576


Explain about alerts in bos, under what situation we need to use alerts?

554


Explain 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)?

539


What Is The Difference Between Oltp And Olap?

671


What is report template in b.o?

580