Set-up Indexes Comparison options

1. Select Comparison Options from Tools main menu.
2. Go to Indexes Comparison tab.
3. Use check-boxes to select/unselect comparison options, according to your strategy.

   Understanding Indexes Comparison options:

   • Case sensitive comparison – if you select this option, index name and index's column(s) name(s) will be compared according to their case. If you omit this option, the case of the names will not affect the comparison. For example, index named "Ind1" and the field "Field1" will be considered as identical to "ind1" ("field1")… [Default value – omitted]
   • Include identical rows in comparison report – if you select this option, identical indexes will be included in the comparison report. If you omit this option, only different or missed on one side indexes will be included in the comparison report. [Default value – selected].
   • Include different rows in comparison report – if you select this option, indexes considered as different will be included in the comparison report. If you omit this option, only identical indexes and indexes which exist on one side, will be included in the comparison report. [Default value – selected].
   • Include missing rows in comparison report – if you select this option, indexes, existing only on one of sides, will be included in the comparison report. If you omit this option, only indexes, existing in both sides will be included in the comparison report. [Default value – selected].
   • Compare index name – if you select this option, the index name will be included in the comparison algorithm. If you omit this option, the index name will be not a part of the comparison algorithm. [Default value – selected].
   • Compare column name - if you select this option, index's column(s) name(s) will compared. If you omit this option, index's column(s) name(s) will not be a part of the comparison algorithm and indexes with the same name, but from different columns will be considered as identical. [Default value – selected].
   • Compare index owner - if you select this option, an index owner (table, schema…) will be a part of the comparison algorithm. If you omit this option, indexes will be compared, not depending on the index owner. [Default value – selected].
   • Compare index uniqueness - if you select this option, the Unique =True/False index's parameter will be a part of the comparison algorithm. If you omit this option, Unique property will not be used during comparison. [Default value – selected].
   • Compare index sort type - if you select this option, the Order = Acs/Desc index's parameter will be a part of the comparison algorithm. If you omit this option, Order property will not be used during comparison. [Default value – selected].