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


Please Help Members By Posting Answers For Below Questions

Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

713


Explain what are the measure objects?

639


is it possible to export the webi reports to crystal reports?with out using businessview?

1914


How to execute the plsql procedure from the report by clicking with mouse?

700


Can you please send me the migration related issues .

1743






Explain what sort of existing documents should business analysts refer to when starting on a new project?

693


what will be the contents for a functional requirements specifications

1873


Explain is there any other repository domains rather than universe, security, document?

661


Explain when we use aggregate awareness function in designer?

670


Explain in detail about type 2(scd),

685


What is difference between webi and infoview?

722


What is the difference between user and versatile user?

669


please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

1630


Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

2696


Can anybody tell me what are the tuning problems?

1675