Women in Technology

Hear us Roar



Article:
  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


Samu

Main Topics Newest First

Showing messages 1 through 1 of 1.

  • Alternate sql query for existing quesry
    2004-12-17 04:34:18  VISHSQL [View]

    Hi