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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-11 : 08:49:17
|
| Sarfaraz writes "Is there any Perfomance decrease in using View?" |
|
|
dsdeming
479 Posts |
Posted - 2002-04-11 : 12:40:23
|
| Usually yes, but it may be mitigated if you create an indexed view. I normally avoid views as much as possible, particularly if they involve complex joins. |
 |
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2002-04-11 : 14:26:03
|
| While views do consume resources like all queries, they may be appropriate for your environment. They're great at linking things together and allowing users to query against the view. They also allow you to hide columns if people aren't supposed to see certain fields.We user report writers against SQL and I always have them against views. |
|
|
|
|
|
|
Creating View in SQL Server