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 |
|
marksta
Starting Member
1 Post |
 Posted - 2007-08-16 : 11:56:52
|
| HiI'm currently experiencing a performance issue with an application that I have developed. For some reason, recently one of the views has had a dip in its performance. When I do a full selection of the view it works fine. However, if I was to select a set of specific fields from the view in my query then it takes an incredibly long time to return any results. This used to work fine, and to the best of my knowledge nothing has changed data wise.Has anyone got any ideas what may cause such a drop in performance?Cheers |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-16 : 23:48:56
|
| Did you check execution plan? |
 |
|
|
|
|
|
Problem with SQL view