Why compound queries narrow results in Firebase - Visual Breakdown

Process Flow - Why compound queries narrow results

Start with full collection

↓

Apply first query filter

↓

Results narrowed to matching docs

↓

Apply second query filter

↓

Results narrowed further

↓

Return final filtered results

Compound queries apply multiple filters one after another, each step reducing the number of matching documents.

Execution Sample

Firebase

db.collection('users')
  .where('age', '>=', 18)
  .where('city', '==', 'NY')
  .get()

This query fetches users who are 18 or older AND live in New York, narrowing results step-by-step.

Process Table

Step	Action	Filter Applied	Documents Matched	Result Explanation
1	Start query	None	All users in collection	No filter yet, all documents included
2	Apply first filter	age >= 18	Users aged 18 or older	Filters out users younger than 18
3	Apply second filter	city == 'NY'	Users aged 18+ AND in NY	Further narrows to users in New York
4	Return results	Final filtered set	Users matching both filters	Only users meeting both conditions are returned

💡 Query ends after applying all filters, returning only documents matching every condition

Status Tracker

Variable	Start	After Step 2	After Step 3	Final
matchedDocuments	All users	Users aged 18 or older	Users aged 18+ AND in NY	Users aged 18+ AND in NY

Key Moments - 3 Insights

Why does the number of documents decrease after each filter?

Each filter removes documents that don't meet its condition, as shown in steps 2 and 3 of the execution_table.

Are documents that fail the first filter checked against the second filter?

No, documents failing the first filter are excluded immediately, so only filtered results are checked in the next step (see step 3).

What happens if no documents match all filters?

The final result is empty, meaning no documents satisfy every condition, as the filters narrow results cumulatively.

Visual Quiz - 3 Questions

Look at the execution_table, how many documents remain after applying the first filter?

A All users in collection

B Users living in NY

C Users aged 18 or older

D Users younger than 18

💡 Hint

Check the 'Documents Matched' column at Step 2 in the execution_table.

At which step does the query narrow results to users living in New York?

A Step 3

B Step 2

C Step 1

D Step 4

💡 Hint

Look at the 'Filter Applied' column in the execution_table for the city filter.

If the first filter was removed, how would the final results change?

A Results would be empty

B Results would include all users in NY regardless of age

C Results would include all users regardless of city or age

D Results would include only users aged 18 or older

💡 Hint

Consider how removing the age filter affects the narrowing process shown in variable_tracker.

Concept Snapshot

Compound queries apply multiple filters one after another.
Each filter reduces the number of matching documents.
Only documents meeting all conditions are returned.
Example: .where('age', '>=', 18).where('city', '==', 'NY')
Filters users 18+ AND living in New York.
Results narrow step-by-step with each filter.

Full Transcript

Compound queries in Firebase work by applying filters one after another. Starting with the full collection, the first filter removes documents that don't meet its condition, narrowing the results. Then the second filter further narrows the results by removing documents that don't meet its condition. This process continues until all filters are applied. The final result includes only documents that satisfy every filter condition. For example, a query filtering users aged 18 or older and living in New York first selects users 18 or older, then from those selects users living in New York. This step-by-step narrowing ensures precise results.