HI, can anybody explain me how performence will decrease if
we create objects using derived tables ?
Answers were Sorted based on User's Feedback
Answer / manoj
Derived Tables decrease the performance because even if you
include one single object from this table the entire query
from the table is executed .
You can see this in the sql Query panel.
hence i would avoid using any derived tables unless
mandatory
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / ashok
by using derived table we can improve the query performance
because that is not created in database it can be designed
at universe designer only.
| Is This Answer Correct ? | 2 Yes | 2 No |
how to optimize the query perfomance in b.o?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
can anybody tell me about issues faced while creating reports
How to execute the plsql procedure from the report by clicking with mouse?
GENARALLY WHAT ARE THE PROBLEMS ARE FACING WHILE CREATING REPORTS?
What is top business?
What are all difference between business objects 6.5 and xi r2?
What is the use of linling the universes?Thanks in advance
What is meant by Adhoc reports?Can any body will explain with examples...Thanks in Advance .........prakash
in sap bi we have wad, then why we go for sap bo
explain about Prompt with example?
Can any please explain FOR EACH AND FOR ALL?