Hi,

By the way can you re-write the query as below and let me know whether it helps.

Select A.* From IMPORTFILE_DeDuped1 A Where

A.Name NOT In (Select B.Name from BIG250MMTABLE...