Which of the following lines correctly represents a Bitmap Index Scan in the output of EXPLAIN in PostgreSQL?

easy📝 Syntax Q3 of 15

PostgreSQL - Performance Tuning

Which of the following lines correctly represents a Bitmap Index Scan in the output of EXPLAIN in PostgreSQL?

AIndex Scan using idx_customer_id on customers

BSeq Scan on customers

CBitmap Index Scan on idx_customer_id using idx_customer_id

DAggregate on customers

Step-by-Step Solution

Solution:

Step 1: Identify Bitmap Index Scan syntax
PostgreSQL EXPLAIN output shows 'Bitmap Index Scan on using ' for bitmap index scans.
Step 2: Compare options
Bitmap Index Scan on idx_customer_id using idx_customer_id matches this pattern exactly.
Final Answer:
Bitmap Index Scan on idx_customer_id using idx_customer_id -> Option C
Quick Check:
Seq Scan and Index Scan have different keywords [OK]

Quick Trick: Bitmap Index Scan line includes 'Bitmap Index Scan on' [OK]

Common Mistakes:

Master "Performance Tuning" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free