Skip to main content
Journey Uncommon Logo
JourneyUncommon
mediumSQLcomposite and partial indexesSingle-choice MCQ

In PostgreSQL, given this partial index, which query is eligible to use it?

CREATE INDEX idx_pending ON orders (customer_id) WHERE status = 'pending';