SQL query - help

[jodugg]

Simple question for the guru's...

2 tables:
table_a – 8mm records
table_b – 1mm records

They each have the same table structure. I need to create a table with every row in table_a that is NOT in table_b.

Since each row (all columns) acts as the “key” I’m selecting all fields concatenated together…unfortunately the hash_aj hint will not work this way. My query has been running for like 11 hrs!

What's a better option?
Thanks in advance.

 

[LKBrwnDBA]

Try MINUS:

Create TAble New_Table
As
Select * From Table_A MINUS Select * From Table_B;

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[IanWaterman]

YOu could also use a union query, union only adds distinct records

Create TAble New_Table
As
Select * From Table_A
Union
Select * From Table_B;


Ian

 

[SantaMufasa]

Ian,

The query you post results in all distinct rows from both tables.

LK's query does as JoDugg specifies: "...every row in table_a that is NOT in table_b".

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
“Beware of those that seek to protect you from harm or risk. The cost will be your freedoms and your liberty.”