I have _isActive field in most of my tables , is it beneficial to use partial index with condition {_isActive:true}
or include the _isActive as one of the field in my index ?
almost all the queries would have the condition _isActive:true
I have _isActive field in most of my tables , is it beneficial to use partial index with condition {_isActive:true}
or include the _isActive as one of the field in my index ?
almost all the queries would have the condition _isActive:true
Hi @Ravi_Tatikonda1,
By reading the description it seems _isActive
is a boolean field. It is beneficial if your query does not read the data that are non true
value. That would trim the index size and can accomodate more required data in memory.
If your reads document that not depending on this field value then you may need to add it to index.
thanks,
Darshan