Code RoomQuery ignores company filter

HardPrep Room Coding #1852

Query ignores company filter

Code reviewDatabases & SQLSenior–Staff~26 min

Review this SQL. The index exists but EXPLAIN still shows a sort + filter, and the query is slow.

What a strong answer looks like

Separate real bugs from style. Rank issues by severity, point at the root cause rather than the symptom, and suggest a concrete fix, specific and kind.

0:00 of about 26 min

Mark a line and say what kind of problem it is.0 findings

1-- existing index:

2CREATE INDEX idx_app ON applications (status, created);

3

4-- the slow query:

5SELECT id, candidate_id, created

6FROM applications

7WHERE company_id = $1

8 AND status = 'submitted'

9ORDER BY created DESC

10LIMIT 20;

Which questions mattered is sealed until you submit. Telling you now would just be handing over the edge cases.