11gR2 : Add hint automatically for a specific query
Hi ,
I have to optimize the following simple query :
select id, name from file_reception ;
that has been executed 100000 times in purpose to check if a data file is received.
To optimize this , i would like to use result cache like :
I have to optimize the following simple query :
select id, name from file_reception ;
that has been executed 100000 times in purpose to check if a data file is received.
To optimize this , i would like to use result cache like :
select /*+ RESULT_CACHE */ id, name from file_reception ;
Is there a tip that allows to add automatically this hint when this query encountered by the optimizer ?
Best regards.
GD.
0