Hello,
To analyze the performance data I am inserting SYS.DM_EXEC_REQUESTS DMV result into table. Under the Command column, it shows CREATE INDEX entries, under Text column it shows insert [dbo].[tblName1] select * from [dbo].[tblName2] for the same process.
My question is, for insert (which is under text column) why it is showing as CREATE INDEX under Command Column. I am not able to relate. Please help.
Regards,
Paul