cancel
Showing results for 
Search instead for 
Did you mean: 

Optimization on SELECT Statement using SORTED INTERNAL Table

karthik_sub
Participant
0 Kudos
151

Hi Team,

I have used the below query using SORTED table, still the system consumes more time for execution.

Key fields in my custom tables are field_name ,seq ,key_value .

In total, I have around 1000 entries in the custom table.

No Buffering available for this custom table.

Kindly guide me on the same. Thanks.

    DATA lt_data TYPE SORTED TABLE OF tp_data WITH UNIQUE KEY field_name seq key_value .

    SELECT  field_name,
                  seq,
                  key_value,
                  add_search,
                  sign,
                  opti,
                  low,
                  high,
                  begin_date,
                  end_date FROM ztmdgc_config
           WHERE  field_name @iv_field_name
           INTO   TABLE @LT_data .

Regards,

Karthik S

Accepted Solutions (0)

Answers (0)