Question regarding query efficiency for fetching items by Boolean value

[ptpaterson]

Hi @Rishi_Kataria and welcome!

You want to check if the published field equals a value, so use the Index terms, not values.

CreateIndex({
  name: "blogs_get_published",
  source: Collection("blogs"),
  terms: [
    { field: ["data", "published"] }
  ]
})

Map(
  Paginate(Match(Index('blogs_get_published'), true)),
  Lambda("ref", Get(Var("ref")))
)

I was just commenting on equalities and inequalities, so I will share that, too

@ptpaterson

Equality and Inequality

You can generally differentiate the way indexes are used by considering if you want to search for equality or for inequality .

• searching for equality (e.g. WHERE A = B ):
  • use Index terms to match exactly
• searching for inequality (e.g. WHERE A < B or WHERE A >= B , etc.):
  • use Index values and the Range function