Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-17580

Warn when using only one of $min or $max index bounds

    • Query Optimization

      In the absence of a fix for SERVER-15168 (now tracked as SERVER-8045), it would be useful to output a warning when a query is issued which uses $min but not $max, or vice-versa. This is because such usage can often have deleterious performance, and is contrary to the intended usage of $min/$max (see DOCS-4015).

      Since the main in-server usage of $min/$max is for sharding, and always specifies both $min and $max, the warning would only occur with user queries that only specify either $min or $max (but not both).

            Assignee:
            backlog-query-optimization [DO NOT USE] Backlog - Query Optimization
            Reporter:
            kevin.pulo@mongodb.com Kevin Pulo
            Votes:
            0 Vote for this issue
            Watchers:
            8 Start watching this issue

              Created:
              Updated: