HI, can anybody explain me how performence will decrease if
we create objects using derived tables ?
- 2 Answers
- 4084 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 domain? How many are there in a basic setup? What are they?
HOW YOU WORKED WITH MULTIPLE DATA SOURCES?IF YES ?HOW DO YOU LINK THEM?
How we will show the pop message while selecting multiple input values more than 10 in Crystal reports or any other reports?
how many reports have u created ? explain a few.
0 Answers Bank Of America, TCS,
What is report template in b.o?
What is package in BO
how will you move the universe/report from development to production?
how do u migrate BO 6.x to XI ? My Mail id is gunal_prabhu@yahoo.co.in
what r the types of joins universe supports
Give some information on report bursting?
what is the syntax for aggregate awareness?
3 Answers Exilant, i-Tree, Wipro,
What is Custom Sorting? In development environment we had applied custom Order on Month which is having the following list of values September,October,March,August and December only.But in Production environment Month is having all LiSt of Values like 12 MOnths(Jan to Dec).So ,How it will effect the Sorting in production environmentof universe and as well as in reporting????? Thanks in advance.
Teradata 
