[Solved] What will be the result of this Firestore query?db.collection('orders').where('status', '==', 'delivered').orderBy('date')Assuming no composite index exists for 'status' and 'date'. | GCP

GCP - Cloud Firestore and Bigtable

What will be the result of this Firestore query?

db.collection('orders').where('status', '==', 'delivered').orderBy('date')

Assuming no composite index exists for 'status' and 'date'.

AThe query will fail and prompt to create a composite index.

BThe query will ignore the orderBy and only filter by status.

CThe query will succeed and return filtered and ordered results.

DThe query will return all documents unordered.

Step-by-Step Solution

Solution:

Step 1: Check if composite index is needed for equality filter + orderBy
Firestore automatically creates single-field indexes for equality filters and orderBy on different fields.
Step 2: Determine if query runs without composite index
Since only one equality filter and one orderBy, no composite index is needed; query runs successfully.
Final Answer:
The query will succeed and return filtered and ordered results. -> Option C
Quick Check:
Equality + orderBy on different fields works without composite index [OK]

Quick Trick: Equality filter + orderBy usually no composite index needed [OK]

Common Mistakes:

Master "Cloud Firestore and Bigtable" in GCP

9 interactive learning modes - each teaches the same concept differently

More GCP Quizzes

What will be the result of this Firestore query?