Skip Navigation
Expand
Report Analyzer not using filter index
Answer ID 8705   |   Last Review Date 03/18/2019

Why is the report analyzer showing that no indexes are used, despite the filter being displayed as indexed?

Environment:

Analytics
Oracle RightNow CX, All versions

Resolution:

The filter used column is populated dynamically depending on the filter values used. For example, if you add a filter on the contact ID in the incidents table (incidents.c_id) and set it to be blank (all contacts), the index on this field will not be used. If you select a particular value as shown in the screenshot below the query will be able to use the index.

Click to Enlarge


Depending on the filter values and which filters are used, the "Index Used" column will give an indication if the index is usable in the current query. 

Note: If a column is indexed it does not necessarily mean that the index can be efficiently used in the database query running behind the report.


For more information relating to indexing, refer to Impact of indexing a custom field.

Available Languages for this Answer:

Notify Me
The page will refresh upon submission. Any pending input will be lost.