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

Will sql server 2005 allow you to reduce the size of a column?

914

What is a partition function in sql server?

1020

what is the difference between a primary key and a unique key? : Sql server database administration

945

How do I edit a stored procedure in sql server?

879

What is transaction server explicit transaction?

965

How to call a function from a stored procedure in SQL Server ?

952

Differentiate between a having clause and a where clause.

923

Is oracle faster than sql server?

884

Does an index slow down updates on indexed columns?

910

How to view existing indexes on an given table using sys.indexes?

1034

Explain the database you used in your final year project?

966

Explain the first normal form(1nf)?

966

What are the parts of a function?

866

What is the difference between ‘having’ clause and a ‘where’ clause?

990

How to configure odbc dsn with different port numbers?

1021