The below select statement is causing a TIME_OUT error.
SELECT rsnum rspos werks lgort INTO TABLE lt_mseg
FOR ALL ENTRIES IN t_zix30
WHERE rsnum = t_zix30-rsnum AND
rspos = t_zix30-rspos.
This select statement is using the index MSEG~R .But still it is causing a time_out error.From DB05 analysis i found that rsnum and rspos are having distinct values.So an index can be created on these fields.
analysis from db05
distinct values 1-10 11-100 101-1000
rsnum 1.587.015 1.579.806 7.006 202
rspos 3.529.702 3.526.466 3.223 12
Can anyone tell me is it feasible to create an index on these fields?