ABAP Performance Tuning - Tips & Tricks
Content
Introduction
Using Selection Criteria
Using Aggregate Functions
Using Views instead of Base Tables
Using the Into Table clause
Modifying a group of lines
Use of Binary Search option
Appending Internal Tables
Using Table Buffering
Use of FOR ALL entries
Proper Structure of the WHERE clause
Proper use of the MOVE statement
Proper use of INNER JOIN statement
Use ABAP SORT instead of ORDER BY
Performance Analysis Tools
  ABAP Performance Tuning - Tips & Tricks
-Using the Into Table clause-
 
Page 5 Of 15

Use of the into table clause of select statement

Instead of appending one record at a time into an internal table, it is advisable to select all the records in a single shot.

 Not recommended

            Refresh: int_fligh.

            Select * from zflight into int_fligh.

             Append int_fligh. Clear int_fligh.

            Endselect.

 

Recommended

            Refresh: int_fligh.

            Select * from zflight into table int_fligh.

 
Stats Box
Vendor Listings (9)
Jobs (3)
Resumes (3)
Tutorials (18)
Articles (22)
Code Snippets (1)
CBTs (17)
Books (4)
Online Training (15)
Latest 5 Tutorial
SAPscript
SAP Mobile Engine
Integrating XML into SAP Business Connector
Lotus Notes Integration
SAP Data Archiving
 
Copyright © 2007 SapDox.com. All rights Reserved.