HI, can anybody explain me how performence will decrease if
we create objects using derived tables ?
- 2 Answers
- 4615 Views
- I also Faced
- E-Mail Answers
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 |
CAN ANY BODY TELL WHAT FUTURE CAREER IN BUSINESS OBJECTS?
can we cretae views in universe level?
what problems you have faced while creating an universe ? tell me an incident and how you went about solving it? thanks in advance
IF I WANT TO INSTALL BO ENTERPRISE PRODUCTS IN WINDOWS 2000 PROFESSIONAL SERVER ,WHAT SHOULD BE THE SYSTEM CONFIGURATION?
Hi All, I have found out this site very interesting and knowledge sharing site.I was wondering if you can tell me where I can get study materials for the BO XI 3.1 or suggest me the one that you have taken recently. Regards, Ace
how many times can use the union operator in a report?
WHAT KIND OF TOOL BO IS?
what is fantrap?
1.what is input level context and output level context in webI? 2.what is a cascading prompt? Where will you give this and how? 3. What is External Strategy?
what is main functional differences between BO and COGNOs?
What is the test methodology for testing BO Universes?
Can more than 1 metric be applied on an analytic in business objects?
Teradata 
