Database View ---- Execution Time

[former_member355168]

Dear experts,

I hv to improve the performance of a report in which a view has been used.

I hv debugged the program, when control goes to query that is fetching data from view, taking very long time.

Can anything be done to improve the performance of the database view.

In view , MKPF , MSEG and MAKT tables has been used.

Regards,

Jaspal Kumar

[Former Member]

MKPF and MSEG are big tables as they store header and item data of material documents created in process...

please zoom in the 'Selection condition used in programs'

also if require, you can try with secondary index (although too much use of secondary index can decrease performance)

You can look the time duration in ST05 trace...

Thanks