Query regarding index utilisation
-
I see there’s a default index being created when a time series collection is created and the nature is that of a compound index
-
is it possible to create another index in this time series collection?
-
when I do an explain of a query selecting records in this collection, I see index pattern is clustered_index pattern
But, I need it to be dedicatedly utilising time series index ,which aligns to my usecase.
- Is it possible to select the index utilisation incase a collection has two indexes for faster data retrieval?
Apologies if my query is too novice level. Needed to understand a bit more