ddic

[Former Member]

1) what happens when is use key fields in a select statement in reverse order ?

2) if i have 1234 fields of an itab if i sort only 1 and 3 then what happens , if i'm using control break statements on them in them then what will happen ?

[former_member194152]

hi,

(1) it will not affect your database selection but obviously reduce performance for ur select querry .

(2) Then for each new combination of field 1 2 3 control break statement will trigger.

Reward if helpful.

Regards

Gagan

[naimesh_patel]

1. It will impact the database performance. So, please don't use like that.

2. If you use the control break on 1 and 3, and your contorl will trigger even if your field 2 has been changed. So, please change your table structure like field1, field3, field2, field4.

Regards,

Naimesh Patel