Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

time_out

Hi,

The below select statement is causing a TIME_OUT error.

SELECT rsnum rspos werks lgort INTO TABLE lt_mseg

FROM 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?

Not what you were looking for? View more on this topic or Ask a question