ANY IDEA ON OPTIMIZER HINTS IN FORM
697852Apr 23 2009 — edited Apr 23 2009..... I have 2 index in my main table one uses jono which is most widely used logic for retrival , 2nd is based on bill_num , I have 2 questions:-
1) I tried using the hint /*+ INDEX(JOHDR_bkup IDX_BILL_bkup ) */ in forms at block level but there was no speed up in retrival ?????? help SOS
2) Can we use 2 hints at block level in a form or we change the hint runtime based on query source .....
Thankx in Advance
DG