Query brings system dowh, needs help

From: gmisassoc <gmisrod_at_access.digex.net>
Date: 1 Mar 1995 07:21:35 -0500
Message-ID: <3j1osf$95b_at_access1.digex.net>

I have two tables and I am running the following query:

SELECT id FROM table1 WHERE id NOT IN
(SELECT id FROM table2)

Both tables are about 20,000 records each. This query is bringing a Sequent to its knees.

What I want are all the ids that are in table1 but are not in table2.

Any help is appreciated.

Please respond to Received on Wed Mar 01 1995 - 13:21:35 CET

This message: [ Message body ]
Next message: PierceED_at_CSUS.edu: "Re: Query brings system dowh, needs help"
Previous message: Chuck Citrano: "testing. Please ignore..."
Next in thread: PierceED_at_CSUS.edu: "Re: Query brings system dowh, needs help"
Reply: PierceED_at_CSUS.edu: "Re: Query brings system dowh, needs help"
Reply: Doug Harris: "Re: Query brings system dowh, needs help"
Maybe reply: Tony Jambu: "Re: Query brings system dowh, needs help"
Reply: Adam Hoffman: "Re: Query brings system dowh, needs help"
Maybe reply: L Carl Pedersen: "Re: Query brings system dowh, needs help"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message