1) we can use views in sp instead of joins to increase the performance of

What are the advantages of using views. Why do we need
views when we have SPs?

Question Posted / reddy

Answer Posted / reddy

1) we can use views in sp instead of joins to increase the
performance of SP.

Is This Answer Correct ?

7 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are two difference between sql azure and azure tables?

161

What is scrollable cursor?

1082

What do you understand by user-defined function in the sql server?

1013

What are page splits?

1058

What is the xml datatype?

1126

Differentiate between a having clause and a where clause.

1010

What is a cache in ssrs?

140

What happens if null values are involved in arithmetic operations?

1050

What are types of storage modes? : sql server analysis services, ssas

1090

Why are views required in the sql server or in any other database?

1004

Can we add our custom code in ssis?

1042

How to test subquery results with the exists operator?

1170

What are the restrictions while creating batches in sql server?

1123

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

1109

What are the differences between union, intersect, and minus operators?

1143