Wednesday, May 6, 2015

Query Optimization

Your query:

FROM##tempa

        ,dbo.tbl_cal_db AS h

First, you need to join them. I think that is why it is taking 20 min. 

Rgds.


This would be the prime issue, you are updating every row in tbl_cal_db multiple times (once for every row in tempa)

No comments:

Post a Comment