Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
 Posted - 2008-03-27 : 12:50:40
|
| Hi,1. Is a View more efficient than a Query (Client Sideor in a Stored Procedure) ?2. If there are table joins, is it better to do in View itself or do it outside ?Thankyou.SrinikaSrinika |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-03-27 : 15:56:41
|
| 1.firing a query on View is not as efficient as firing a query on direct tables2.You can directly join on main tables itself unless you have specific need for view (like hiding sensitive data) |
 |
|
|
|
|
|
Efficiency comparison - Query vs View