04-09-2008 1:16 PM
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.
04-10-2008 8:57 AM
There are different hints for the different database platforms.
For up-to-date information please read the SAP notes, search 'hint DB2'.
Siegfried
04-10-2008 11:07 AM
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.