Women in Technology  Hear us Roar    SQL Subqueries Subject:  
Alternate sql query for existing quesry Date:   2004-11-18
23:11:01 From:   Samu My query given below is very slow to
execute  "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
Main Topics Oldest First  Showing messages 1 through 1 of 1.
• Alternate sql query for existing quesry     2004-12-17
04:34:18  VISHSQL [View]