这是indexloc提供的服务,不要输入任何密码
Skip to content

[Bug]:Index Not Used for Query on 'Keyword' Field Despite Index Being Created #404

@jasonnan1

Description

@jasonnan1

Version

0.2.0

App

  • Cursor
  • Windsurf
  • VSCode
  • VSCode Insiders
  • Claude Desktop
  • Other

Affected Models (if applicable)

  • Claude 3.5 Sonnet
  • Claude 3.7 Sonnet
  • GPT-4a
  • o4-mini
  • Other

Bug Description

My prompt is as follows:Please query the data where the value in the Keyword field is 187.72.65.17.
Why is it that even though I have already used the create-index method to add a query index for Keyword, when I perform a database query using this prompt, it still performs a full collection scan and shows the following error message:
{"find": "Index check failed: The find operation on "mcp-test.products" performs a collection scan (COLLSCAN) instead of using an index. Consider adding an index for better performance. Use 'explain' tool for query plan analysis or 'collection-indexes' to view existing indexes. To disable this check, set MDB_MCP_INDEX_CHECK to false."}

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions