got the difference .. thankx...:-)

Is there any difference between table scan and index scan?

Find the SP attached. The tables which this SP queries are of the order of 6-7 GBs each and have around 5 lakh rows.

PS: I was customizing the reports and...

I just tested some SPs and found that after using NOLOCK the execution time of the queries reduced from 35 to 31 secs approx.... Now this is very tempting... :w00t:

But...

disc space might be an issue.. i will revert back with the error log details when i see the error again...

Thankx for you replies... 🙂

Cheers,