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
- 5198 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 many tables can an universe contain is their any limit to insert tables in the universe?
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
What are different types of saving options in web intelligence?
webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??
What is scope of analysis ?
what is difference between Rich client web intelligence and Boxir2 web intelligence
How to link two different universes ?
how to sort on a particular object,that object is not picked up while creating the cross tab but we need to sort on the object that is not in the cross tab????
2 Answers Infosys, Keane India Ltd,
GENARALLY HOW MANY UNIVERSES ARE CREATE FOR EACH PROJECTS?
Difference between Decode and Case?
8 Answers Polaris, TCS, Wipro,
why we are using derived tables ?how it will help?
I have one vertical table and in that table there are 10 rows. I want to add one row between 4-5 row. How it possible in WebI.
Teradata 
