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 |
|
Zack
Starting Member
26 Posts |
 Posted - 2008-05-19 : 15:55:37
|
| Greetings,I recently started working with a database that uses several views, none of which are indexed. I've compared the execution plans of querying against the view versus querying against the tables and as best I can tell from my limited knowledge the two seem to perform equally. It seems to me that having the view is just one more thing I need to keep track of.I've done some google searches but haven't found anything that really tells me which performs better, querying the view or the tables directly. Generally speaking which is better? Thanks in advance for your replies. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-19 : 16:23:22
|
| Generally speaking, they would have equivalent performance.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
 |
|
|
neversaydie
Starting Member
3 Posts |
Posted - 2008-05-19 : 22:01:36
|
| THX upstairs |
|
|
|
neversaydie
Starting Member
3 Posts |
Posted - 2008-05-19 : 22:27:40
|
| have you do any test? |
|
|
|
|
|
|
Query View vs Query Tables directly