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