语句如下:
select *
from (select t.id,
t.product_code,
t.product_is_gift,
t.default_picture_url,
t.product_cname,
t.product_ename
from product t
join product_merchant pm on pm.product_id = t.id
and pm.default_merchant = 1
where t.id < :1
and t.category_id = :2
and t.IS_DELETED = 0
and t.CAN_SALE = 1
order by id desc)
where rownum < 2
在awr报告里,gets/per exec 为47,330.91,但是我单独执行时(把两个参数换为值),在执行计划里显示gets为4,请教各位高手,是什么原因,
|