Prefix Indexes

XMLWordPrintableJSON

    • Type: New Feature
    • Resolution: Unresolved
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: Index Maintenance
    • None
    • Query Optimization
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None

      It would be great if we could specify indexes that only index on the prefix of a field. i.e. for BinData on the first n bytes, for strings on the first n characters, etc. This might not work on all data types but it is a great tool for trimming index sizes when applicable.

            Assignee:
            [DO NOT USE] Backlog - Query Optimization
            Reporter:
            Benjamin Darfler
            Votes:
            19 Vote for this issue
            Watchers:
            29 Start watching this issue

              Created:
              Updated: