Status for a Mixed Filter
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'
Díreach CREATE/ALTER/DROP — ní gá SELECT ina dhiaidh sin.
Logáil isteach chun stair na n-aighneachtaí a fheiceáil
Logáil isteachLogáil isteach chun an Meantóir IS a úsáid
Logáil isteach