Please corrrect me .

Former Member — Mon, 13 Nov 2006 21:52:00 GMT

Instead of using

SELECT BUKRS BELNR GJAHR BLART BLDAT BUDAT XBLNR HWAER

FROM BKPF INTO TABLE TBKPF

WHERE BUKRS IN COMPCODE

AND BSTAT NE 'M'

AND BSTAT NE 'D'

AND BUDAT IN POSTDATE

AND BLART IN R_BLART

%_HINTS ORACLE 'INDEX (BKPF BKPF______Z1)'.

order by primary key.

Is it better to use :

SELECT BUKRS BELNR GJAHR BLART BLDAT BUDAT XBLNR HWAER

FROM BKPF INTO TABLE TBKPF

WHERE BUKRS IN COMPCODE

AND BUDAT IN POSTDATE

AND BLART IN R_BLART

%_HINTS ORACLE 'INDEX (BKPF BKPF______Z1)'.

order by primary key.

DELETE TBKPF WHERE bstat <> 'M' AND bstat <> 'D'.

Re: Please corrrect me .

Former Member — Mon, 13 Nov 2006 22:15:24 GMT

Neither. So ling as COMPCODE has values, this should be what you want:

SELECT bukrs belnr gjahr blart bldat budat xblnr hwaer
  FROM bkpf INTO TABLE tbkpf
  WHERE bukrs IN compcode
  AND bstat IN (' ', 'A', 'B', 'S', 'V', 'W', 'Z')
  AND budat IN postdate
  AND blart IN r_blart

Rob

Take out the HINTS. It's likely forcing the wrong index.

Message was edited by:

Rob Burbank

topic Re: Please corrrect me . in Application Development and Automation Discussions

Please corrrect me .

Re: Please corrrect me .