Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

adf View Criteria full access table

moi9082234Jun 6 2017 — edited Jun 8 2017

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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 6 2017
Added on Jun 6 2017
2 comments
128 views