如何使用多个OR语句重构SQL查询以获得更好的性能？

SELECT column1, column2
FROM table1
WHERE condition1
UNION ALL
SELECT column1, column2
FROM table1
WHERE condition2
UNION ALL
SELECT column1, column2
FROM table1
WHERE condition3;

SELECT column1, column2
FROM table1
WHERE column1 IN (value1, value2, value3);

SELECT column1,
       CASE
           WHEN condition1 THEN result1
           WHEN condition2 THEN result2
           WHEN condition3 THEN result3
           ELSE default_result
       END AS result
FROM table1;

SELECT t1.column1, t1.column2
FROM table1 t1
JOIN (
    SELECT column1
    FROM table1
    WHERE condition1
    UNION ALL
    SELECT column1
    FROM table1
    WHERE condition2
    UNION ALL
    SELECT column1
    FROM table1
    WHERE condition3
) AS subquery ON t1.column1 = subquery.column1;

SELECT column1, column2
FROM table1
WHERE MATCH(column1) AGAINST('value1 value2 value3');