HI, can anybody explain me how performence will decrease if
we create objects using derived tables ?
- 2 Answers
- 4076 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 we link the Universes from two different sourcess?Explain?
What is the difference B/W Variable & Formula? what is ment by incompatable object error in the report level?
WHAT IS SYNCHRONIZATION IN BOXI?
what is the different between link and join ?
How were the reports scheduled and how to resolve unexecuted documents?
U r project in which stage in implementation?
Explain in Detail about Measure Objects? and what is the use of it? How to create it?
what is diff between Decode and case ? Give some Example?
define universe parameters?
how do u implement dense rank in bo reports?
What is the definition of derived table ?
Can anybody tell me about issues faced while creating universe. thanks in advance
Teradata 
