2007 Nov 23 3:58 AM
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 ?
2007 Nov 23 4:16 AM
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
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
2007 Nov 23 4:07 AM
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
2007 Nov 23 4:16 AM
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
| User | Count |
|---|---|
| 6 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |