How to specify a particular index for DB2 database when using SQL in ABAP

[Former Member]

Is this format for Oracle?

-

---

select *

into -

---

from vbrk CLIENT SPECIFIED

where erdat in erdat

and mandt EQ sy-MANDT

%_HINTS ORACLE 'INDEX("VBRK" "VBRK~ZER")'

.

-

---

For the index 'VBRK~ZER' was defined before,it only includes one field 'VBRK-ERDAT'.

How can i tell Sap to use this index while processing SQL in DB2?

Thanks advance.

[Former Member]

Is this format for Oracle?

-

---

select *

into -

---

from vbrk CLIENT SPECIFIED

where erdat in erdat

and mandt EQ sy-MANDT

%_HINTS ORACLE 'INDEX("VBRK" "VBRK~ZER")'

.

-

---

For the index 'VBRK~ZER' was defined before,it only includes one field 'VBRK-ERDAT'.

How can i tell Sap to use this index while processing SQL in DB2?

Thanks advance.

[Former Member]

There are different hints for the different database platforms.

For up-to-date information please read the SAP notes, search 'hint DB2'.

Siegfried

[Former Member]

Thanks for your info.

A interesting situation was found that the right index was used while removing 'mandt' field from where clause with 'client specified' option.