Status for a Mixed Filter

#1008

The order list searches orders either for user_id = 1 or for status = 'paid'. The user side is already supported, but status is not. Add an index on status so the status side does not scan the whole order list.

Speed this query up with an index

SELECT * FROM orders WHERE user_id = 1 OR status = 'paid'

Solo CREATE/ALTER/DROP — no hace falta un SELECT al final.

Inicia sesión para enviar

Aquí aparecerá el resultado de tu consulta