Index usage on queries when multiple indices are defined for a space.
Article ID: KB0092744
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveSpaces | - |
| Not Applicable | - |
Description
Resolution:
The ActiveSpaces query optimizer will automatically use the appropriate index depending on the query being issued independent from the number of defined indexes.
2.) Index selection for queries is dictated by the use of order by in the filter. The use of order by in a query filter can override the indices that would normally be used by the query.
Consider the following query: key < 10 order by id .
3.) Each index will be stored in memory. It is expected that the memory usage grows with the number of configured indexes.
The ActiveSpaces query optimizer will automatically use the appropriate index depending on the query being issued independent from the number of defined indexes.
Note:
2.) Index selection for queries is dictated by the use of order by in the filter. The use of order by in a query filter can override the indices that would normally be used by the query.
Consider the following query: key < 10 order by id .
If the user has an index on “key” and another tree index on “id”, ActiveSpaces will pick the index on “id” over the index on “key” and perform a table scan to validate “key < 10".
3.) Each index will be stored in memory. It is expected that the memory usage grows with the number of configured indexes.
Issue/Introduction
Index usage on queries when multiple indices are defined for a space.
Additional Information
Feedback
Yes
No
Powered by
