What is the difference between derived table and views?
which one gives better performance?
- 2 Answers
- 23908 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / pradeep mishra
Always View is better than Derived Tabels because it
fetches the Data Directly through the Database So as per
the Performance related it's too good.
But,When we want to use @Function (@variable,@prompt) in
your Query that time it's only possible in Derived
Table,not in the VIEWS.
| Is This Answer Correct ? | 21 Yes | 0 No |
Post New Answer View All Answers
Can anybody tell me what are the tuning problems?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
What is the difference between absolute and relative div positioning?
how to create reports on screech?
How can you first report in Business Objects by using broadcast agent?
What is package in BO
What is thumbnail?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
can anybody tell me about complicated object you have created
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
How to generate the report from excel sheet?
Which versions are used in the bo dashboard work?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
What we need to discuss with designer before starting the universe designing.
