Alternative for the union in SQL where-clause

advertisements

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