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 |
|
sfunds
Starting Member
7 Posts |
 Posted - 2006-01-30 : 03:08:18
|
| Hi,I want to know the effect of creating number of views on 2-3 tables involing cross join onthe performance while doing Insert, delete , update and search of perticular tables |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-01-30 : 06:42:06
|
| The query plan will be generated incorporating the views - i.e. the optimiser will look inside the viwes and take that into account.That sounds like it doesn't matter how many views you use but the problem is that they increase the complexity of the query that the optimiser has to deal with making it less likely that it will get a good plan - and also hiding what is going on from the developer preventing them from writing efficient code.In the worst case views can stop the server working entirely - I've seen it take minutes (and I suspect hours but I stopped it) to generate a query plan with a lot of nested views.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
sfunds
Starting Member
7 Posts |
Posted - 2006-01-30 : 13:03:13
|
| Thanks for the info |
|
|
|
|
|
|
Effect of View