topic Full table scan in Application Development and Automation Discussions

Full table scan

Former Member — Mon, 17 Nov 2008 12:59:47 GMT

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.

Re: Full table scan

h_senden2 — Mon, 17 Nov 2008 13:03:20 GMT

add a WHERE clause with fields that use an index

regards

Hans

Re: Full table scan

Former Member — Mon, 17 Nov 2008 13:14:12 GMT

Hi,

SELECT <Field-names>

FROM <table-name>

INTO TABLE <tab-name>

WHERE <Condition>

Thanks

NItesh

Re: Full table scan

Former Member — Mon, 17 Nov 2008 14:12:48 GMT

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