Hi,
I created a view based on entity, and I also created a view criteria based on indexes ,but when I traced all queries in database I found that adf scan in full table.
I want here to optimise my database access to oblige adf use indexes because I have huge tables.
for example :
SELECT * FROM (SELECT
T_V_TEST.ID,
T_V_TEST.ABRV,
T_V_TEST.LIB,
T_V_TEST.ID_COM
FROM
T_V_TEST) QRSLT WHERE ( ( (ID_COM = :Par_Com ) ) )
the explain plan contains this line
TABLE ACCESS FULL T_V_TEST
such as I have an index in id_com. how to oblige adf use this index in view criteria.
any suggestions
thanks