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 |
|
Lumbago
Norsk Yak Master
3271 Posts |
 Posted - 2004-08-01 : 06:31:19
|
| I don't use views at all in my db and unfortunately I don't know too much about them. Is the performance of a view joined with another few tables better than a select that joins all the tables?I'm asking because what I need to increase performance on a section of the db is basically the results of a view, but I'm suspecting that a view woun't increase performance, just make the code easy to maintain.--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-08-01 : 11:21:55
|
quote:
Originally posted by LumbagoI'm suspecting that a view woun't increase performance, just make the code easy to maintain.
you got it. There are a couple of other areas where views are nice ot use, but none of them involve increasing performance.-ec |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-01 : 14:46:48
|
| The only time views increase performance is when you are partitioning tables and using indexed views. In this case, they can significantly increase performance. Otherwise, they are generally slower or, at best, equal in speed to a SELECT. They are many times used for security, giving various people different views of applicable data.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2004-08-01 : 15:33:43
|
| Bummer. Well, at least I understand to some extent what they do. It will be a pain in the neck to work around it and take me forever but I'll find a way. Thanx fellas... |
|
|
|
|
|
|
View insight