Hi diat150,

Looks complicated... hopefully if you can gather some clues for me I can help out.

Please run the SET SHOWPLAN_ALL ON command followed by your query. For example:

SET SHOWPLAN_ALL...

Hi asranantha,

1) please supply the full CREATE TABLE sql (including table name) of both tables.

2) how is the data being copied? Using SQL? Using a tool? Please provide...