adf View Criteria full access table

moi9082234

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

Timo Hahn

User, tell us your jdev version, please!

I testet this with the HR DB schema and the query

select * from (select * from employees) qrslt where department_id = :pID;

To get

and using

select * from employees where department_id = :pID;

I  get

So it's using the index in both cases. May be the optimizer has choosen to not use the index, but this is not ADFs fault.

Timo

moi9082234

Hello Timo,

you are right I have a mistake of choice of index.

thanks