Hello,
We are using SQl Server2000 and have to run this below query for the results. The query itself is taking more that 10 seconds. I tried the query on the query analyzer itself and took the same amount of time. the query is:
the parameters at the end of the query nikon and d70are dynamice parameters. I also have indexes on a.itemno,a.icode2,a.iedesc,b.itemno,b.ptp01,b.pcprc1,b.pcprc9,c.itemno
i'm new to database performance issues. Could someone please guide me on how to make this query run faster?. I would really be appreciative. Thanks alot for your time and guidance.
Mala
[ October 10, 2005: Message edited by: Mala Sharma ]
[edited to add line breaks]
[ October 10, 2005: Message edited by: Jeanne Boyarsky ]