Full table scan

[Former Member]

Hi,

The following statement is going for full table scan.

SELECT MANDT MOLGA TRFGB TGBTX

from t510g

INTO TABLE it_payareatxt.

Kindly suggest any modifications can we do to this statement to avoid full table scan.

[h_senden2]

add a WHERE clause with fields that use an index

regards

Hans

[Former Member]

Hi,

SELECT <Field-names>

FROM <table-name>

INTO TABLE <tab-name>

WHERE <Condition>

Thanks

NItesh

[Former Member]

Example of a single scan:

DATA wa        TYPE sflight. 
DATA seatsfree TYPE I. 

SELECT SINGLE * FROM sflight INTO wa 
       WHERE 
         carrid   = 'LH '      AND 
         connid   = '0400'     AND 
         fldate   = '20010228'. 
         FLDATE   = '19950228'. 
seatsfree = wa-seatsmax - wa-seatsocc. 

WRITE: / wa-carrid, wa-connid, wa-fldate, seatsfree.

Regards,

Ali