cancel
Showing results for 
Search instead for 
Did you mean: 

equality-index-filter on ordering index-type

Highlighted
UnboundID _-rc-_
UnboundID
0 Kudos

equality-index-filter on ordering index-type

Motorola has an ordering index for modifyTimestamp (lastModified) defined as:
    1)   attribute                                            modifytimestamp
    2)   index-entry-limit                                    4000
    3)   substring-index-entry-limit                          The value of the index-entry-limit configuration option will be used.
    4)   maintain-match-count-for-keys-exceeding-entry-limit  false
    5)   exploded-index-entry-threshold                       4000
    6)   index-type                                           ordering
    7)   substring-length                                     6
    8)   prime-index                                          false
    9)   prime-internal-nodes-only                            false
    10)  equality-index-filter                                (objectClass=cabApplicationGroup), (objectClass=cabBroadbandDevice), (objectClass=cabBroadcastGroup),
                                                              (objectClass=cabBroadcastMember), (objectClass=cabDeletedResource), (objectClass=cabDevice),
                                                              (objectClass=cabDynamicMember), (objectClass=cabEnterpriseContactList),
                                                              (objectClass=cabEnterpriseGroup), (objectClass=cabGroupProfile), (objectClass=cabIDENUser),
                                                              (objectClass=cabLMRDevice), (objectClass=cabLMRIdentity), (objectClass=cabLMRTalkGroup),
                                                              (objectClass=cabNonRoleMember), (objectClass=cabNotificationTarget),
                                                              (objectClass=cabPSAppAuthorization), (objectClass=cabPTTLoggerDevice),
                                                              (objectClass=cabPersonalGroup), (objectClass=cabPublicSafetyApplication),
                                                              (objectClass=cabSubscriptionProfile), (objectClass=cabUNSUserProfile), (objectClass=cabUser)
    11)  maintain-equality-index-without-filter               true
 
Their question:
We have "modifyTimestamp" attribute in most of our objectClasses and it mirrors the meta.lastModified operational attribute value. We filter and sort based on this modifyTimestamp in our queries, so would like to setup an ordering index to make these queries fast. I seem to remember discussing the "equality-index-filter" definition with a list of comma separated objectClass is not supported, though dsconfig accepts this definition and that these should be created as separate index per objectClass. Is my memory on this right?
 
We tried setting these up as a separate index, but are seeing an error that an index with the same name exists (i.e. when we try to add the second index on 'modifyTimestamp' for the second objectClass on the list). Can you please help clarify?