Skip to Content

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

Slect query taking time when executed

Hai Friends,

The following is my select query

Select zmatnr

zshift

kwmeng

zdate

from ztable

into table it_table

where zmatnr = so_matnr

and zdate = so_date

and delnum = '0'

and prtnr > '0'.

Here zmatnr and zdate are only the key fields. The other two are not. This query takes time. Shall i index those fields. Is it right. Explain the right situation to index the table.

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