The best method to add new values only from destination to source
===

I have two tables. table1 (source) and table2 (destination). I want to whole records in table2 to be copied to table1 if and only if the record is not already exists in table1. I used the following statement:

    INSERT INTO test.dest
    SELECT * 
    FROM test.source
    WHERE NOT EXISTS(SELECT * 
                     FROM test.dest
                     WHERE (source.DomainName=dest.hostnmae)
                     );

That i found in a previous post. My question: Is there another better method to speed the process??