Is there a way to specify which index to use in the select statement?
Amit Mishra replied
Have a look at the following code.
WHERE process_type IN git_t_type
AND object_type = gc_subobject
AND object_id IN git_t_no
%_HINTS ORACLE 'INDEX("CRMD_ORDERADM_H" "CRMD_ORDERADM_H~OID")'.
Here I am using the index OID defined for the table CRMD_ORDERADM_H.
<b>Please reward points and close the thread if your question has been answered.</b>