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 |
|
francism
Starting Member
22 Posts |
 Posted - 2008-09-08 : 15:40:55
|
| When creating a view, is it inefficient to join to another view? Should one join to the individual tables in the view instead of the view?I am creating views for MS CRM v3 and they are nasty!Microsoft CRM 3 - SQL Server 2000 |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-09-08 : 16:08:58
|
I don't think it makes a difference - look at the query plans and test it both ways to be sure.
elsasoft.org |
 |
|
|
francism
Starting Member
22 Posts |
Posted - 2008-09-08 : 16:42:48
|
| Thank you.Microsoft CRM 3 - SQL Server 2000 |
|
|
|
|
|
|
View - Is it inefficient to join to another view?