Schema Indexes
Indexes that keep record queries and sorting fast.
Last updated
Indexes that keep record queries and sorting fast.
Where: Database β Collections β collection β Schema editor β List tab
Screenshot TODO β capture comes from testing-plan area 03-database-collections.
There is no separate index-management screen. The dashboard reads the collection's MongoDB indexes (via listIndexes) and uses them in the schema editor's List tab to warn you before a slow sort ships to your team.
Each index lists one or more fields as its keys; _id always has its built-in index. A sort on field F is only index-covered when F is the first key of an existing index. For example, an index with keys [{ "field": "lastName" }, { "field": "firstName" }] covers sorting by lastName, but not by firstName.
On the List tab, every selected column that is not covered gets a β marker with the tooltip No index on this field β sorting may be slow on large collections. The same coverage rule decides whether the records list's default sort runs fast.
Indexes themselves are created on the MongoDB side (your own cluster or the managed Flex cluster), not from this screen.
Endpoints: Database β Collections.
Last updated