Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Indexes

Hi All,

Is there a way to specify which index to use in the select statement?

Thanks

Tags:
replied

Hi Anurag,

Have a look at the following code.

SELECT COUNT(*)

FROM crmd_orderadm_h

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>

Regards,

Amit Mishra

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question