Loading...

XML

Word

Printable

JSON

Type: New Feature
Resolution: Unresolved
Priority: Major - P3
Fix Version/s: None
Affects Version/s: None
Component/s: Index Maintenance
Labels:
None

Assigned Teams:

Query Optimization
Case:
CAR Domain/s:
None

Aha! Reference:
None
Tracking Level:
None
Risk Status:
None
Exec Notes:
None
Goal Name(s):
None
Goal Link:
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.

is duplicated by

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

Closed

related to

SERVER-14784 Add expression indexes

Backlog

SERVER-15090 Improve Text Indexes to support partial word match

Backlog

Assignee:: [DO NOT USE] Backlog - Query Optimization
Reporter:: Benjamin Darfler
Participants:: [DO NOT USE] Backlog - Query Optimization, Benjamin Darfler, Chad Kreimendahl, charity majors, Grigorii Eremeev, Mark Callaghan
Votes:: 19 Vote for this issue
Watchers:: 31 Start watching this issue

Created:: Jun 14 2011 03:20:30 PM UTC
Updated:: Dec 06 2022 05:43:10 AM UTC

Details

Description

Attachments

Issue Links

Activity

People

Dates