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.
Thanks again.