Interested to Buy Any Domain ? << Click Here >> for more details...
HI, can anybody explain me how performence will decrease if
we create objects using derived tables ?
- 2 Answers
- 5306 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 |
How to get two dimension objects in a same block which are comming from two different contexts ?
What is the size of data base?
How to link two different universes ?
1.what is the functionality of "Event Server" in BOXIR2? 2.what happen if RAS server is down in BOXIR2
1. what is import wizard and its purpose ? 2. what is publishing wizard and its purpose ?
why you create universe and creating reports based on that? why dont we go for crystel reports and generate reports directly?tell me the advantages?please answer to this question.
IS THERE ANY OTHER TOOL AVAILABLE TO DESIGN/CREAT UNIVERSE? EXCEPT UNIVERSE DESIGNER
What is user docs and how to use this option in bo?
what are cascading prompts explain with steps
How to create Universe using Flat file in BO6.0
Explain what is the difference between business requirement document and use case document.
why do we use crystal reports rather than webintelligence reports ?
Teradata 
