MongoDB Index for both int and text

Question

I have this query:

{
 branchId: 23,
 Name:  /.*ABC.*/i
}

I created index

{
branchId: 1,
Name: 1
}

I can see branchId scan for the index, but Name not, how can I make this query faster?

Gibbs · Accepted Answer · 2022-02-02 03:44:13Z

1

Since you have regex and it is not a prefix expression and it is case insensitive, thus index is not used.

You can try using text index. But there are other restrictions when using text index.

Case insensitive regular expression queries generally cannot use indexes effectively.

answered Feb 2, 2022 at 3:44

Gibbs

23.1k14 gold badges84 silver badges147 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1