"select TempTable.* from TempTable where TempTable.col1 + TempTable.col2 not in (select col1 + col2 from OrigTable)"
Both the tables referenced have 90,000 records
and combination of col1 and col2 is the primary key.
Can you suggest some alternative fast method to execute my above mentioned query
© 2015, O’Reilly Media, Inc.
All trademarks and registered trademarks appearing on oreilly.com are the property of their respective owners.