Index in hint is not used - Access full PO_HEADERS_ALL
Hi,
I'm in oracle e-business suite R12.
I'm working on a query which taking some time in running.
I'd like to optimize it as possible.
As i have a access full in table PO_HEADERS_ALL, i add a hint in the qyery :
SELECT /*+ INDEX(PO_HEADERS_ALL PO_HEADERS_U1) INDEX(PO_HEADERS_ALL PO_HEADERS_N1) all_rows */
But the indexes are not used. (except the "all rows"). Why ? They are valid in the database.
When i execute an explain plan, i have always the access full in the PO_HEADERS_ALL.
In the query i use the following field of PO_HEADERS_ALL :
I'm in oracle e-business suite R12.
I'm working on a query which taking some time in running.
I'd like to optimize it as possible.
As i have a access full in table PO_HEADERS_ALL, i add a hint in the qyery :
SELECT /*+ INDEX(PO_HEADERS_ALL PO_HEADERS_U1) INDEX(PO_HEADERS_ALL PO_HEADERS_N1) all_rows */
But the indexes are not used. (except the "all rows"). Why ? They are valid in the database.
When i execute an explain plan, i have always the access full in the PO_HEADERS_ALL.
In the query i use the following field of PO_HEADERS_ALL :
0