Indexing for More Efficient Cache Queries

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.