Viewing 5 posts - 1 through 5 (of 5 total)
I added a clustered index to the tables and it seems to have fixed the issue.
Thanks for your help.
August 16, 2007 at 6:23 am
#727299
Thanks for your help, that's what I did. I'm going to make the recommended changes and see what happens.
August 15, 2007 at 2:29 pm
#727201
I figured out how to get the plan in text format.
|--Table Insert(OBJECT[DTM].[dbo].[t_DTM_DATA_STAGING2]), SET[DTM].[dbo].[t_DTM_DATA_STAGING2].[CP] = [DTM].[dbo].[t_DTM_DATA_STAGING].[CP],[DTM].[dbo].[t_DTM_DATA_STAGING2].[CO] =...
August 15, 2007 at 12:23 pm
#727144
I ran the Display Est. Execution plan, not sure how I can post it as it's a graphical image.
It is doing a Table scan on t_DTM_DATA_STAGING. I don't...
August 15, 2007 at 11:37 am
#727136
September 20, 2006 at 7:41 am
#661489