索引失效的问题
select * from CARDINFO_154 where ROWNUM=1 AND START_182 = '190000001157362'
会使用索引
select * from CARDINFO_154 where ROWNUM=1 AND START_182 <= '190000001157362' AND END_182 >= '190000001157362'
也会使用索引 COST 4
select * from CARDINFO_154 where ROWNUM=1 AND START_182 = '190000001157362'
union all
select * from CARDINFO_154 where ROWNUM=1 AND START_182 <= '190000001157362' AND END_182 >= '190000001157362'
不会使用索引 COST 3000多
我对 start_182 end_182 都建了索引 start_182和end_182也建了组合索引
数据量在60W左右