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 |
|
zhangn
Starting Member
29 Posts |
 Posted - 2009-12-16 : 04:37:28
|
| Hi allI am new to sql. I have a very stupid question here. I understand a simple view is just a SQL query. When I use where in addition to the view. What will be the system procdure?a) Open the entire view first, then apply the where conditionb) Pass to view (select statement) together with where condition to the system. The reason I am asking is if it is the case in (a), it will make the query a lot slower than normal sql query. many thanks!Ning |
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
|
|
|
|
|
View performance question