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.
- Create Indexes Using a Coherence Function
This method applies to the Coherence cache provider only. It is not the preferred method. - Creating an Index Using a Domain Object Override Setting
This method applies both to the TIBCO and Coherence cache providers. You can create an unordered index in the project’s Cluster Deployment Descriptor (CDD) using a domain object setting. - Enabling Explicit Tuple Format for DataGrid Fields
You can set a property in the CDD so that they are instead stored as tuples. That is, TIBCO BusinessEvents attempts to create explicit space structures for each entity type. - Query the Cache Using BQL Queries
In order to execute the queries, you must first enable a dynamic query session.
Copyright © TIBCO Software Inc. All rights reserved.