pradeep mishra


{ City } pune
< Country > india
* Profession * programmer analyst
User No # 42304
Total Questions Posted # 0
Total Answers Posted # 1

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 21
Users Marked my Answers as Wrong # 0
Questions / { pradeep mishra }
Questions Answers Category Views Company eMail




Answers / { pradeep mishra }

Question { TCS, 24102 }

What is the difference between derived table and views?
which one gives better performance?


Answer

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