topic Re: Indexing in Application Development and Automation Discussions

Indexing

Former Member — Wed, 12 Nov 2008 06:58:07 GMT

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.

Re: Indexing

former_member386202 — Wed, 12 Nov 2008 07:02:12 GMT

Hi,

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

Regards,

Prashant

Re: Indexing

Former Member — Wed, 12 Nov 2008 07:02:12 GMT

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