K kojak Member Mar 24, 2003 #1 I have a procedure which needs two indexes, but it use all the time just one. Does anybody know a hint that the select use both important indexes? I tried with /*+ append index(table_name index_name) (index(table_name index_name2) */ but it doesn't work. Thanks for help
I have a procedure which needs two indexes, but it use all the time just one. Does anybody know a hint that the select use both important indexes? I tried with /*+ append index(table_name index_name) (index(table_name index_name2) */ but it doesn't work. Thanks for help
C CTzen Member³ Mar 24, 2003 #1 According to Oracle Documentation (.../DOC/server.817/a76992/hints.htm#4561)the syntax of the INDEX hint is: /*+ INDEX ( table index [[index] index] ... ) */ ... So in you case, /*+ INDEX(table index1 index2) */ should work. Thanks, Slava
According to Oracle Documentation (.../DOC/server.817/a76992/hints.htm#4561)the syntax of the INDEX hint is: /*+ INDEX ( table index [[index] index] ... ) */ ... So in you case, /*+ INDEX(table index1 index2) */ should work. Thanks, Slava
