What is the difference between derived table and views?
which one gives better performance?
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
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Explain what are the measure objects?
is it possible to export the webi reports to crystal reports?with out using businessview?
How to execute the plsql procedure from the report by clicking with mouse?
Can you please send me the migration related issues .
Explain what sort of existing documents should business analysts refer to when starting on a new project?
what will be the contents for a functional requirements specifications
Explain is there any other repository domains rather than universe, security, document?
Explain when we use aggregate awareness function in designer?
Explain in detail about type 2(scd),
What is difference between webi and infoview?
What is the difference between user and versatile user?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
Can anybody tell me what are the tuning problems?