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 |
|
p2bl
Yak Posting Veteran
54 Posts |
 Posted - 2002-12-31 : 02:03:07
|
| we r developing a build a infomation system which contains many complex queries.And our developers has create a lot of views,much of them nested ,none of them can be indexed.But I find search the view could be very slow,while using store procedure will get results quickly.So,when I should use views?Should I search in view?By the way,how do I know my SP is recompiled?thanks a l lot.And happy new year!========================look! |
|
|
|
|
|
As many views as I can?