EXPRESS_IXSCAN
Short Description
Optimized index scan
Detailed Description
EXPRESS_IXSCAN is a special execution stage in MongoDB, introduced in version 8.0, that stands for “express index scan.”
In simple terms:
- It means MongoDB was able to recognize your query as a simple operation that can be handled with a highly optimized, fast index scan, bypassing the usual (more complex) query planning process.
Why does this matter?
- When you see EXPRESS_IXSCAN in your explain plan, it means MongoDB used a "shortcut" to scan the index for your query—making the operation faster and more efficient.
- This usually appears for specific, straightforward query patterns where MongoDB can quickly determine the best plan, such as simple indexed lookups.
Summary:
- EXPRESS_IXSCAN is a super-fast, optimized way MongoDB can use indexes for certain queries.
You don’t need to do anything special to use EXPRESS_IXSCAN—MongoDB will apply it automatically when your query matches the criteria for this optimization.
Additional Links
Search online
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.