For large tables, with millions or rows, a comparison operation may take considerable time. Data compare allows you to set where clauses so that you can read and compare only the rows you need to. When defining the where clause, by default, the same filter is applied to both tables. If you wish a different filters for each of the tables, you can un-check "Use the same where clause".
 |
Do not include the "where" keyword in the where clause. Simply enter the SQL condition, in the same way you would write it in any Oracle tools. |
|
Validate the where clause before comparing the data. This ensures that the clause is syntactically correct. |
|
We strongly recommend basing the where clause on the data key columns. You may include additional columns, but all data key columns must be included in the where clause. Not having a data key column could produce false missing records during the comparison. |