![](https://img-blog.csdnimg.cn/20201014180756738.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SAP ABAP Optimize
Gangelwn
坚持。。。等待中~~
展开
-
Using A Subquery
Using two selects :SELECT * FROM SPFLI INTO TABLE T_SPFLI WHERE CITYFROM = 'FRANKFURT' AND CITYTO = 'NEW YORK'.SELECT * FROM SFLIGHT AS F INTO SFLIGHT_WA FOR ALL ENTRIES IN T_SPFLI WHERE SEATSOCC AND CARRID = T_SPFLI-CARRID AND CON原创 2011-03-27 14:50:00 · 718 阅读 · 0 评论 -
fixed and unfixed length strings
<br />Character fields (fixed length) <br />Runtime: 1 microseconds <br />*data c1(200) type c.<br />*data c2(200) type c.<br />*data c3(400) type c.<br />c1 = 'mysap'.<br />c2 = '.com'.<br />concatenate c1 c2 into c3.<br /><br />String (unfixed length) <b原创 2011-03-27 15:35:00 · 792 阅读 · 0 评论 -
Single Read Sorted vs hashed tables
<br />READ on a unique sorted table <br />* Entries: 1000<br />* Line width: 100, key width: 20<br />* STAB is a unique sorted table, 250 entries are read<br />DO 250 TIMES.<br /> N = 4 * SY-INDEX.<br /> READ TABLE STAB INTO WA WITH TABLE KEY K = N.<br /原创 2011-03-27 15:22:00 · 854 阅读 · 0 评论 -
Building unique standard hashed tables
<br /><br />One-step approach <br />* Entries: 1000, Duplicates: 250<br />* Line width: 100, Key width: 20<br />* ITAB2 takes 750 entries with unique key K<br />REFRESH ITAB2.<br />LOOP AT ITAB1 INTO WA.<br /> READ TABLE ITAB2 WITH KEY K = WA-K<br />原创 2011-03-27 15:20:00 · 643 阅读 · 0 评论 -
Building unique sorted hashed tables.
<br />INSERT in a sorted table with unique key <br /><br />* Entries: 1000, Duplicates: 250<br />* Line width: 100, Key width: 20<br />* ITAB2 takes 750 entries with unique key K<br />REFRESH ITAB2.<br />LOOP AT ITAB1 INTO WA.<br /> INSERT WA INTO TABLE I原创 2011-03-27 15:17:00 · 841 阅读 · 0 评论 -
Joining internal tables.
<br />Naive join: loop ITAB1, read ITAB2 w/key <br />Runtime: 732 microseconds <br />* Entries: 1000 (ITAB1), 300 (ITAB2)<br />* Line width: 100<br />* Both tables sorted by unique key K ascending<br />LOOP AT ITAB1 INTO WA1.<br /> READ TABLE ITAB2 INTO W原创 2011-03-27 15:15:00 · 581 阅读 · 0 评论 -
Secondary indices
<br />No secondary index => linear search <br /> <br />* Entries: 1000, Line width: 100<br />* Key width: 20<br />* The READ locates the 500th entry.<br />READ TABLE ITAB INTO WA<br /> WITH KEY DATE = SY-DATUM.<br />IF SY-SUBRC = 0.<br原创 2011-03-27 14:57:00 · 784 阅读 · 0 评论 -
FOR ALL ENTRIES vs DB2 JOIN
<br />http://it.toolbox.com/blogs/sap-on-db2/for-all-entries-vs-db2-join-8912<br /> <br /> All abap programers and most of the dba's that support abap programmers are familiar with the abap clause "for all entries". Most of the web pages I visited recently转载 2011-03-27 15:49:00 · 1552 阅读 · 0 评论 -
Typed vs untyped Parameters
<br />Untyped parameters <br />Runtime: 5 microseconds <br />PERFORM UP1 USING 10 M6-DIMID M6-ZAEHL M6-ISOCODE M6-ANDEC M6-PRIMARY.<br />FORM UP1 USING<br /> REPEAT<br /> DIMID<br /> ZAEHL<br /> ISOCO原创 2011-03-27 15:36:00 · 1087 阅读 · 0 评论 -
Case vs Perform i Of
<br />* (I = 5 in this test)<br /> CASE I.<br /> WHEN 1. PERFORM PV1.<br /> WHEN 2. PERFORM PV2.<br /> WHEN 3. PERFORM PV3.<br /> WHEN 4. PERFORM PV4.<br /> WHEN 5. PERFORM PV5.<br /> WHEN 6. PERFORM PV6.<br /> WHEN 7. PERFORM PV7.<br /> WHEN 8. P原创 2011-03-27 15:29:00 · 699 阅读 · 0 评论 -
Part Seq access Hashed vs sorted
<br />Partial sequential access on a sorted table <br />* Entries: 10000, Line width: 100<br />* key width: 60, Subkey width: 20<br />* HTAB is a hashed table, 2000 entries are read<br />* Key fields: K, DATA<br />LOOP AT HTAB INTO WA WHERE K = SUBKEY.<br原创 2011-03-27 15:18:00 · 691 阅读 · 0 评论 -
Nested loops
<br />Straightforward nested loop <br />Runtime: 8,987 microseconds <br /><br />* Entries: 100 (ITAB1), 1000 (ITAB2)<br />* Line width: 100<br />* Both tables sorted by key K<br />LOOP AT ITAB1 INTO WA1.<br /> LOOP AT ITAB2 INTO WA2<br /> W原创 2011-03-27 15:13:00 · 697 阅读 · 0 评论 -
Intersection of internal tables
<br />Using a sorted table temporarily <br />Runtime: 101 microseconds <br /><br />* Entries: 200 (ITAB1), 100 (ITAB2)<br />* Intersection: 50 (ITAB3)<br />* Line width: 100, Key width: 20<br />STAB1 = ITAB1.<br />REFRESH ITAB3.<br />LOOP AT ITAB2 ASSIGNIN原创 2011-03-27 15:12:00 · 1034 阅读 · 0 评论 -
Supply Demand vs select
<br />SELECT:<br /> <br />SELECT * FROM SBOOK INTO SBOOK_WA UP TO 10 ROWS.<br /> SELECT SINGLE AIRPFROM AIRPTO INTO (AP1, AP2)<br /> FROM SPFLI<br /> WHERE CARRID = SBOOK_WA-CARRID<br /> AND CONNID = SBOOK_WA-CONNID.<br /> SELE原创 2011-03-27 14:54:00 · 826 阅读 · 0 评论 -
Modifying a set of lines directly
<br /><br />Modifying all lines completely <br />* Entries: 100 (outer table), 20 (inner table)<br />* The entries to be modified: 50<br />* Actually, only the component FLAG is updated.<br />* However, the complete lines are moved.<br />LOOP AT ITAB INTO原创 2011-03-27 15:38:00 · 871 阅读 · 0 评论