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 is local temp table?

699

What is the difference between resultset and resultsetmetadata?

696

What type of locking occurs during the snapshot generation? : sql server replication

1082

What are the advantages of stored procedure in sql server?

628

Are null values the same as that of zero or a blank space?

783

What is meant by datasource?

679

What is scrollable cursor?

744

What is Command line parameters in PLSQL.?

757

How to connect Azure federated root database and apply federation in entity framework?

101

Can one drop a column from a table?

744

What is single-user mode?

690

How does recursive cte works in sql server?

709

How to use column default values in insert statements in ms sql server?

714

What is rtm version in sql server?

693

What happens if null values are involved in comparison operations?

712