All Questions

Filter by
Sorted by
Tagged with
0
votes
1answer
219 views

Can't optimize a nested query using indexes

There are two tables containing hundreds of thousands of records: client and task. It's necessary to query the following: SELECT id, (SELECT status FROM task t WHERE t.client_id = c.id AND ...