SharonInGeorgia
asked on
ORACLE SLQ - Comparing records in 2 tables
Table 2 retrieves data from existing fields in Table 1. The system also creates additional fields in Table 2. Not all fields are transfered from Table 1 to Table 2. These tables may have millions of records so efficentcy is important.
I need to compare that the records are accurately populated in Table2 from Table1.
TABLE 1 TABLE 2
Field1 Field1
Field2 Field2
Field3 Field3
Field4
Field5
Field6
Field7
I need to compare that the records are accurately populated in Table2 from Table1.
TABLE 1 TABLE 2
Field1 Field1
Field2 Field2
Field3 Field3
Field4
Field5
Field6
Field7
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
In this case, I would probably use UNION ALL instead of UNION, which should avoid an extra sort, although the results are the same.
ASKER