Indexing

[Former Member]

hi all guru's,

I am working on a report which is giving dump due to exeeding of its execution time. on debugging i knew that its because of MSEG table which s being used in the report. wat i wana know is how to use indexing in a report to reduce the execution time. Please let me know.

Thank you all.

[former_member386202]

Hi,

Pass all the keys in where clause while selecting data from MSEG, you can also create index on MSEG using SE11.

Regards,

Prashant

[Former Member]

Hi Bal,

If the problem with selecting data from MSEG

then try to use all primary key fields in select statement

if u doesn't have all primary keys data then go for secondary index

go to mseg table in SE11 and find for secondrty indexes and use proper in u r statement

if u not found then create new one but get approval befor creating

Kiran