如果做批量搜索，一下两个语句，哪一个更好呢？

[chenrulongmaster]

explain
SELECT * FROM t_news_root WHERE user_id = 'pressuretestuseridxxxx4580' AND case_id = '4580' AND news_id = '593c5128b5c073a52d10fb7070ed7d7b'
UNION 
SELECT * FROM t_news_root WHERE user_id = 'pressuretestuseridxxxx753' AND case_id = '788' AND news_id = '593c5128b5c073a52d10fb7070ed7d7b'

explain
SELECT * FROM t_news_root WHERE (user_id = 'pressuretestuseridxxxx4580' AND case_id = '4580' AND news_id = '593c5128b5c073a52d10fb7070ed7d7b')
OR (user_id = 'pressuretestuseridxxxx753' AND case_id = '788' AND news_id = '593c5128b5c073a52d10fb7070ed7d7b');

[来了老弟]

你好，

从当前 sql 执行计划，

第一条 indexscan 肯定要比 第二条 tablescan 要更优，具体可根据业务和 sql 的效能进行选择，