topic Re: ddic in Application Development and Automation Discussions

ddic

Former Member — Fri, 23 Nov 2007 03:58:13 GMT

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 ?

Re: ddic

former_member194152 — Fri, 23 Nov 2007 04:07:21 GMT

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

Re: ddic

naimesh_patel — Fri, 23 Nov 2007 04:16:35 GMT

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