Resolution:
Description
=========
How to validate if indexing is being used  in TIBCO BusinessEvents (BE) ?

Environment
==========
BusinessEvents 4.x and 5.x

Resolution
=========
On executing queries, the usage of indexing can be validated in one of the following ways.

1). Check the query agent logs after executing the query. It should have something like the following in the logs which means the indexing has been applied.

lter:[LikeFilter(ChainedExtractor(.get$2zefname(), .getString()), fname100)]
2 GMT -8 snatraj-T510.na.tibco.com Info [SwingWorker-pool-3-thread-1] - [query.stream] [query-class] query-class:1609016:1 cache filters have been optimized
ter:[LikeFilter(ChainedExtractor(.get$2zefname(), .getString()), fname100)]

2). Using the Java Visual VM, connect to the cache server. Go to the profiler tab and click on CPU profiling. The count of applyIndex can be seen increasing each time the indexing is being applied.

How to validate/confirm if indexing is being used in TIBCO BusinessEvents (BE) ?