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

Can we call future method from queueable?

1064

How much memory that we are using in Logshipping Concept?

1806

While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

111

Explain timestamp datatype?

983

what is checksum in sql server.........???

1698

How to restore performance issues and how to check?

2013

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

997

Does windows server 2016 come with sql server?

939

What is merge join?

1202

What is Cross Join and in which scenario do we use Cross Join?

1021

What is a linked server in sql server?

1083

What is cross join in sql server joins?

1155

What is indexing a document?

1042

What's new in sql management studio for sql server? : sql server management studio

1072

What is mapping schema?

1038