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

Create index option to limit an index using the first N characters of the field

    • Type: Icon: Improvement Improvement
    • Resolution: Duplicate
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • None

      In nearly all SQL implementations you can create indexes with a limitation on the length of the originating content that is indexed. For example:

      CREATE INDEX part_of_name ON customer (name(10));
      – creates an index using the first 10 characters of the name column

      This would allow for several benefits:

      • more configurable and useful indexes
      • less memory and/or disk space requirements for indexes
      • higher performance indexing
      • higher performance sorting

            Assignee:
            Unassigned Unassigned
            Reporter:
            sallgeud Chad Kreimendahl
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: