drad 读取优化过程

1 开始 abap语句是这样的
    SELECT SINGLE drad~dokar drad~doknr drad~doktl
      INTO (drad-dokar ,
            drad-doknr ,
            drad-doktl)
    FROM drad
    INNER JOIN draw
              ON drad~dokar = draw~dokar AND
                 drad~doknr = draw~doknr AND
                 drad~dokvr = draw~dokvr AND
                 drad~doktl = draw~doktl
    WHERE drad~dokob = 'MARA' AND
          drad~objky = <f_data>-matnr AND
          draw~loedk = '' .

通过跟踪，发现他最慢
2 第一次优化
    EXEC SQL.
      select drad.dokar, drad.doknr, drad.doktl
       from drad inner join draw on
         drad.mandt = draw.mandt and
         drad.dokar = draw.dokar and
         drad.doknr = draw.doknr and
         drad.dokvr = draw.dokvr and
         drad.doktl = draw.doktl
       where rownum = 1
       and