I’ve attempted the Lab 4.2 returning error in the 3 attempts .
The index i’ve suggested was the Solution Index adding partialfiltering on the match query condition
The description clearly states that the desired result should be the smallest index possible
Keep in mind that there might be several indexes that resolve this error, but we’re looking for an index as small as possible that services this command.
Comparing my partial index with the Lab Solution , the partial index returned smaller size.
Partial index: 3735552
Lab index: 6320128
Running the lab query in both cases returned same result : 588629 documents
What Am I missing? why is not valid a partial index in this lab ?