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

How do I find the sql server database version?

1014

Create and insert into temp table in sql server?

1036

What are the disadvantages of primary key and foreign key in SQL?

1116

What is the main purpose of having conversation group?

900

Explain ranking functions?

1054

What is difference between table aliases and column aliases? Do they affect performance?

970

How to count rows with the count(*) function in ms sql server?

1019

What command would you use to create an index?

1056

Explain indexes disadvantages?

1090

What is inner join? Explain with an example?

1225

what is database replication? : Sql server database administration

1072

Can we install sql server 2016 on windows 7?

1141

What is trigger explain with program?

986

What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas

981

What is a cursor, index in sql?

1075