ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.

advertisement

AddThis Social Bookmark Button
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


1 to 1 of 1
  1. Alternate sql query for existing quesry
    2004-12-17 04:34:18  VISHSQL [View]

1 to 1 of 1