Posted by Erland Sommarskog on 11/02/61 11:34

xu,wei (xuw@lucent.com) writes:
> Thanks so much. I use the ASP + Sql Server2000, I guess the problem
> caused by so many "left join". There are a lot of data in database now.
> I have created some indexes. ( I thinks there are not big problems for
> this indexes.) I want create some indexes on views but after my test I
> found it is same speed as create the indexes on tables. Hope you can
> give more help.

Unfortunately I can only refer to what I said my previous post. There is a
limit of what can be done over newsgroups. Performance tuning a query given
only the query text is impossible - need to know table and indexes for
that. And for a complex query like this, I would need more than so. Even
with access to the database, it can be a difficult task.

I did mention two things you could check:
1) What happens if you exclude the call to the UDF?
2) Is there an index on CPR_PATH.PROJ?

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]