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)
 SQL XML Stored procedure takes a long time to run

Author  Topic 

srisell
Starting Member

1 Post

Posted - 2002-10-03 : 17:23:19
We have a stored procedure which uses SQLXML(I would say that it is a complex one). It runs very slow. We have 7 select statements and in atleast 4 of them we join like 6 tables. I think that these joins must be slowing it down. But is there any way I can make it to run faster? I tried using views, it didn't make much of a difference. Is there any possibility I can overcome that problem? Thanks

   

- Advertisement -