测试库走索引生产库没有走索引什么情况
0
[待解决问题]
select *from(
select t.*, rownum as rid from (
select
a.*,
b.intekey_applyname as applyname,
c.inte_crorg_name as inteOrgName
from sjzx_interface_log a,sjzx_interface_key b,
sjzx_interface c where a.INTE_LOG_KEY=b.intekey_key and a.INTE_LOG_INTEID=c.inte_id
order by a.inte_log_requestdata desc) t )
where rid >0 and rid < 11;
索引：INTE_LOG_KEY，INTE_LOG_INTEID，inte_log_requestdata ；
测试库看执行计划走了索引，但是在生产库没有使用索引，求解
