Uploaded image for project: 'Documentation'
  1. Documentation
  2. DOCS-14680

DOCS-14680 Investigate changes in SERVER-58057: Support ascending and descending indexes on time-series measurements

      Downstream Change Summary

      When the feature flag 'featureFlagTimeseriesMetricIndexes' is enabled, users can create ascending and descending indexes on time-series measurement fields.

      Description of Linked Ticket

      For ascending indexes, a createIndexes command on a time-series collection measurement field:

      {
          createIndexes: “abc”,
          indexes: [ { key: { a : 1 } } ]
      }
      

      will be equivalent to the following operation on the underlying buckets collection:

      {
          createIndexes: “system.buckets.abc”,
          indexes: [ { key: { control.max.a : 1, control.min.a : 1 } } ]
      }
      

      For descending indexes, a createIndexes command on a time-series collection measurement field:

      {
          createIndexes: “abc”,
          indexes: [ { key: { a : -1 } } ]
      }
      

      will be equivalent to the following operation on the underlying buckets collection:

      {
          createIndexes: “system.buckets.abc”,
          indexes: [ { key: { control.min.a : -1, control.max.a : -1 } } ]
      }
      

            Assignee:
            Unassigned Unassigned
            Reporter:
            backlog-server-pm Backlog - Core Eng Program Management Team
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved:
              2 years, 39 weeks, 2 days ago