regex - MongoDB avoid using the index -
my scenario same 1 described here:
mongodb regular expression indexed field
to summarise, when using index $regex query returns 700ms slower when not use index. unfortunately cannot use simple prefix queries optimise against index.
i can't drop index because required queries not involve regex.
is possible bypass index , mongodb scan table directly?
Comments
Post a Comment