in where
clause i am using like
SELECT name
FROM products
WHERE id IN (
SELECT product_id
FROM orders
UNION
SELECT 1);
it taking time to perform union
.
please provide some other alternative to improve my query performance
what about
select name from products
where id in (select product_id from orders)
or id = 1