Partial index vs including field in index

Working with Data
1

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

2

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