SQL 中 Hint Oracle的用法

 (1).
select BKPF~BUKRS
         BKPF~BELNR
         BKPF~GJAHR
         BKPF~BLART
  into corresponding fields of table I_BKPF
  from BKPF
   where BKPF~BUKRS = P_BUKRS"公司代码
    and ( blart = 'WE'
    OR   BLART = 'RE' )
*    and  BKPF~GJAHR = P_GJAHR"年度
*   AND  bkpf~monat = p_monat"期间
*    and  BKPF~BUDAT >= FIRST_DAY
    and  BKPF~BUDAT <= LAST_DAY
    %_hints oracle 'index(BKPF"2")'.


(2).
SELECT * FROM spfli
INTO TABLE t_spfli
%_HINTS ORACLE 'INDEX("SPFLI" "SPFLI~001")'.

(3).

   select * up to 10 rows from csks
                          where kokrs <> space and
                                kostl <> space
                          %_hints oracle 'index(csks"J")'.