1,126
edits
Difference between revisions of "IBM CMOD Composite Indexes"
IBM CMOD Composite Indexes (view source)
Revision as of 14:42, 21 October 2020
, 14:42, 21 October 2020Changed image size for CMOD Indexed Fields graphic.
m (One too many semicolons in CMOD v10.5 link.) |
m (Changed image size for CMOD Indexed Fields graphic.) |
||
| Line 12: | Line 12: | ||
Composite Indexes are database indexes that are created by adding the values of two or more fields together. If the fields selected for the composite indexes are mostly unique (high specificity or cardinality) the index may be very large, but it should be able to identify a single record -- and be extraordinarily efficient in the process. In order to be effective at reducing the duration of queries, ALL of the fields that appear in the composite index must also be set to be 'Required' fields in the Folder configuration. | Composite Indexes are database indexes that are created by adding the values of two or more fields together. If the fields selected for the composite indexes are mostly unique (high specificity or cardinality) the index may be very large, but it should be able to identify a single record -- and be extraordinarily efficient in the process. In order to be effective at reducing the duration of queries, ALL of the fields that appear in the composite index must also be set to be 'Required' fields in the Folder configuration. | ||
[[File:RequiringIndexedFields.png|Improving IBM CMOD Performance by Requiring Indexed Fields ]] | [[File:RequiringIndexedFields.png|800px|Improving IBM CMOD Performance by Requiring Indexed Fields ]] | ||
= Usage = | = Usage = | ||