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 SubQuery in SQL Server 2008

546

How do you manipulate data?

489

What is BCP? When does it used in sql server 2012?

576

Explain “not null constraint” in sql server?

522

What are the differences between lost updates and uncommitted dependencies?

537

What are different type of Collation Sensitivity?

552

Explain the advantages of merge replication?

505

What is tempdb in sql server?

509

What is a system database and what is a user database?

576

How many triggers you can have on a table?

531

What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

585

Explain sub-query?

567

What is coalesce and check constraint in sql server?

539

List down some advantages of sql stored procedure?

552

How to delete all rows with truncate table statement in ms sql server?

485