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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Slow Running view in sql

Author  Topic 

skazemi
Starting Member

3 Posts

Posted - 2009-05-28 : 18:58:43
I have a view in a Relational Database in sql server2000.
My view is Fast But When I add a condition on view Running it is very slow
My view have multiple select statment.
Please Help me what view is slow where run this query:
select * from myview where myfield1>5
(I dont change Table of view but When add some table(not relate with my view ,my view run fast again!!!))Please Send Answer to skazemibox@gmail.com
Tanks

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2009-05-28 : 20:48:28
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
Go to Top of Page
   

- Advertisement -