Setting the file. One moment.
Chapter 08 · Firebase Firestore
Subchapter 8.4
references/enterprise/indexes.mdMarkdown5 KBView on GitHub
Indexes helps to improve query performance. Firestore Enterprise edition does not create any indexes by default. By default, Firestore Enterprise performs a full collection scan to find documents that match a query, which can be slow and expensive for large collections. To avoid this, you can create indexes to optimize your queries.
An index consists of the following:
The order and sort direction of each field uniquely defines the index. For example, the following indexes are two distinct indexes and not interchangeable:
name (ascending) and population (descending)name (descending) and population (ascending)Dense indexes: By default, Firestore indexes store data from all documents in a collection. An index entry will be added for a document regardless of whether the document contains any of the fields specified in the index. Non-existent fields are treated as having a NULL value when generating index entries.
Sparse indexes: To change this behavior, you can define the index as a sparse index. A sparse index indexes only the documents in the collection that contain a value (including null) for at least one of the indexed fields. A sparse index reduces storage costs and can improve performance.
You can use unique index option to enforce unique values for the indexed fields. For indexes on multiple fields, each combination of values must be unique across the index. The database rejects any update and insert operations that attempt to create index entries with duplicate values.
| Query Type | Index Required |
|---|---|
| Simple Equality`where(“a”, | Single-Field Index on field a |
| : “==”, 1)` : : | |
| Simple Range/Sort`where(“a”, | Single-Field Index on field a |
| : “>”, 1).orderBy(“a”)` : : | |
| Multiple Equality`where(“a”, | Single-Field Index on field a and |
: “==”, 1).where(“b”, “==”, 2) :b` : | |
| **Equality + | Composite Index on field a and |
: Range/Sort**where("a", "==", : b` : | |
| : 1).where(“b”, “>”, 2)` : : | |
| Multiple Ranges`where(“a”, | Composite Index on field a and |
: “>”, 1).where(“b”, “>”, 2) :b` : | |
| **Array Contains + | Composite Index on field tags |
: Equality**where("tags", : and active` : | |
| : “array-contains”, : : | |
| : “news”).where(“active”, “==”, true)` : : |
If no indexes is present, Firestore Enterprise will perform a full collection scan to find documents that match a query.
Your indexes should be defined in firestore.indexes.json (pointed to by
firebase.json).
Define a dense index:
{
"indexes": [
{
"collectionGroup": "cities",
"queryScope": "COLLECTION",
"density": "DENSE",
"fields": [
{ "fieldPath": "country", "order": "ASCENDING" },
{ "fieldPath": "population", "order": "DESCENDING" }
]
}
],
"fieldOverrides": []
}Define a sparse-any index:
{
"indexes": [
{
"collectionGroup": "cities",
"queryScope": "COLLECTION",
"density": "SPARSE_ANY",
"fields": [
{ "fieldPath": "country", "order": "ASCENDING" },
{ "fieldPath": "population", "order": "DESCENDING" }
]
}
],
"fieldOverrides": []
}Define a unique index:
{
"indexes": [
{
"collectionGroup": "cities",
"queryScope": "COLLECTION",
"density": "SPARSE_ANY",
"unique": true,
"fields": [
{ "fieldPath": "country", "order": "ASCENDING" },
{ "fieldPath": "population", "order": "DESCENDING" }
]
}
],
"fieldOverrides": []
}Deploy indexes only:
bash npx firebase-tools@latest -y deploy --only firestore:indexes