Hi All, This is my first post in this forum. I am facing a problem regarding performance of SQL server 2000. From application (front end as PERL), I am trying to generate reports with selected fields. Because of this kind of functionality, query is becoming huge with so many join statements. Once I run this big query, the entire application slows down. I tried indexes. In index tuning wizard the performance improvance is coming as 0%. Kindly help me in any of the following: 1) performane of query should become more that in less time results should appear. or 2) when the big query is runnning for remaining queries, it should not affect the performance. Thanks in advance.