Skip to Content

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

Secondary index creation on the table

Hi Experts,

The select statement mentioned below taking very huge time in production.I checked for the indexes but thereis no index created with these fields and primary key's also not used in select statement.How can I create the secondary index and plese tell me the order of fields should be given in secondary index.

select * from dfkkop into corresponding fields of table t_dfkkop

where vtref like 'EPC%' and

( ( augbd = '00000000' and

xragl = 'X' )

or

( augbd ge w_clrfr and

augbd le w_clrto ) ) and

augrd ne '03' and

zwage_type in s_wtype.

Thanks&Regards,

Sam.

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