Thanks for the information. Let me try that. This code is embedded in a procedure. I guess I can do the same while executing the procedure also.

Suresh

Since once of the table seems to be a memory table, I do not know how to capture the query plan for the same. Is there a trace that I...