trunc日期会影响索引的使用吗?
在做ebs11.0的二次开发时,碰到这个问题,
我做了一下测试,发现并没有影响
例:
select *
from inv.mtl_material_transactions t
where t.organization_id = 4
--and t.transaction_date < trunc(to_date('&f_date', 'yymmdd
-------使用索引是MTL_MATERIAL_TRANSACTIONS_N5,列是ORGANIZATION_ID, TRANSACTION_DATE
select *
from inv.mtl_material_transactions t
where t.organization_id = 4
and trunc(t.transaction_date)<to_date('&f_date', 'yymmdd') ---
-------使用索引是MTL_MATERIAL_TRANSACTIONS_N5,列是ORGANIZATION_ID, TRANSACTION_DATE
select *
from inv.mtl_material_transactions t
where t.organization_id = 4
and t.transaction_date < trunc(to_date('&f_date', 'yymmdd'))
-------使用索引是MTL_MATERIAL_TRANSACTIONS_N5,列是ORGANIZATION_ID, TRANSACTION_DATE
请兄弟们帮忙分析一下