Firestore Enterprise, array indexes failure
In Firestore Enterprise, array indexes can be created in the index management view without throwing any errors or warnings. However, when executing queries that rely on array operations (such as array-contains or array-contains-any), the query engine completely ignores the created array index and falls back to a full table scan.
This creates significant issues for setups migrating from Firestore Standard, where array indexes are commonly used to handle multi-document references and array-based lookups.
1
vote