hard20 pts · first answer countsindexing

IN list plus ORDER BY

Index (status, created_at). The query is WHERE status IN ('new','retry') ORDER BY created_at LIMIT 50. Why might a Sort step still appear?

A.IN lists can never use an index in PostgreSQLB.Each status is a separate sorted run, so runs must be mergedC.The index must list created_at first for IN to workD.LIMIT is applied before the WHERE clause runs

Discussion 0

Join free to post in the discussion.

IN list plus ORDER BY

Discussion 0

Related questions