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
- 5074 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 |
What is the difference between the Webintelligence and desktopintelligence?
what is Scope of Analysis
how do we apply sql query on selected variables?
working with Business Objects 6.1(a), i m facing a problem. when i save the BO report containing chart aswell as table in .xls then the null vlues in the table automatically are converted to 0, thereby istorting the chart also. please provide me the solution as soon as possile.
1.what is the use of migration.(converting one version to another) 2. what r the migration issues faced while migrating from Bo5.x to BOXIR2 n how 2 resolve it. 3. provide some .ppt/material to understand abt migration easily.
How would you format some text using css to be verdana and bold?
How maually can i define ? If thousends of records exists in a table?
How many universe dfi you create if you have 2 years of experience in BO
what are the disadvantages of alias?
Can anyone tell me how to display (calculate )Turn Around Time between two dates in the BO Report? Thanks in Advance
where are objects are stored ?
I have a report with two queries and each query have prompt on some object. Tell me how many times it will ask for the input?
Teradata 
