摘要： 查看awr报告过程发现一个隐式转换导致的索引失效问题，做做记录awr中语句实际消耗大40多w逻辑读代入变量后测试很快SQL> SELECT a.order_prod_amount, b.prod_cost_price FROM user_sess a, PR_DO_T b WHERE a.prod_id = b.prod_id AND a.order_no = '125924325287';Elapsed: 00:00:00.00Execution Plan---------------------------------------------------------- 阅读全文