Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Find Difference between 2 Tables, 22 GB each, on unique key

Find Difference between 2 Tables, 22 GB each, on unique key

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Tue, 12 Apr 2005 12:03:52 +0530
Message-ID: <B5587533FCBD4344ADB8290B3EDDA1220404A12D@kecmsg14.ad.infosys.com>


Folks

Need to get=A0the difference records between 2 tables each of size 22GB = (each containing 32 Million rows). The temp tablespace is 30GB.

Unique index exists on the respective fieldname on which to check for = difference.

Which approach faster/most efficient way?

  1. Select <fieldname> from Table 1 MINUS Select <fieldname> from Table = 2? - If so what would be the consumption of TEMP Tablespace? = Additionally how to=20
  2. some Other SQL script=20
  3. PL/SQL script
  4. Will doing a FULL index ONLY Scan be faster than a FULL Table scan?

=A0

Machine configuration - 4 cpu's and 1GB DIMM RAM.=20 OS version - Unix Sun Solaris machine Version not known. Oracle version -=A0 8.1
Nature of application -=A0Joins and inserts production issue -=A0 Yes
Tables being accessed by other applications - YES, during certain time = slot. We have abt 12-14hrs when they are not touched by any application.
=A0

Thanks

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Apr 12 2005 - 02:39:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US