Indexing for More Efficient Cache Queries

Note:
TIBCO BusinessEvents Express
 This section relates to Cache OM functionality and is not relevant if you are using TIBCO BusinessEvents Express edition.

When you use Oracle Coherence as the cache provider, you can index concept and event properties to make searches faster. You can index more than one of an entity type’s properties.

The query optimization you set up is used by C_Query*() functions, and by snapshot queries, available in TIBCO BusinessEvents Event Stream Processing add-on.

You can create the indexes in the following ways.