Hi All,
I am having a difficult time optimizing a procedure to run more effeiently, and am hoping that someone may give some advise...
Basically, I have 2 tables:
-- Raw (staging table, max 50,000 records)
-- Lookup (over 200 million records and growing)
I have a package developed to import...