Additional information about the Complete Compare advanced option Include Only Generated Objects was provided for r7.3.11.
The Complete Compare advanced option Include Only Generated Objects works for indexes only when you use a Database Level Compare. It does not apply for the Logical, Physical, and Logical Physical Level Compare.
The following table illustrates the conditions when indexes are filtered in Complete Compare for Database Level Compare with this advanced option selected:
|
Index |
Generate |
Generate As Constraint |
Filtered in Complete Compare |
|
PK |
Not selected |
Not selected |
Yes |
|
FK |
Not selected |
Any value |
Yes |
|
AK |
Not selected |
Not selected |
Yes |
|
IE |
Not selected |
Any value |
Yes |
Note: In this table, Any value means that the Generate As Constraint option can be selected or not selected.
The following table illustrates the conditions when indexes are not filtered in Complete Compare for Database Level Compare with this advanced option selected:
|
Index |
Generate |
Generate As Constraint |
Filtered in Complete Compare |
|
PK |
Any value |
Selected |
No |
|
PK |
Selected |
Any value |
No |
|
FK |
Selected |
Any value |
No |
|
AK |
Any value |
Selected |
No |
|
AK |
Selected |
Any value |
No |
|
IE |
Selected |
Any value |
No |
Note: In this table, Any value means that the Generate As Constraint option can be selected or not selected.
The Indexes are compared in Complete Compare even though the Generate or Generate As Constraint options (or both) are not selected in the Index Editor because you are using the Physical Level Compare. Using the Include Only Generated Objects option has no effect on Indexes except when you use the Database Level Compare.
The following illustrations demonstrate this behavior. The FK indexes DONOTGENERATE and XIF1SCN_API_AUD_CNFM_SHMT with the Generate check box not selected appear in the Physical Level Compare and are hidden in the Database Level Compare.
Example: Physical Level Compare

Example: Database Level Compare

| Copyright © 2013 CA. All rights reserved. |
|