Performace issue for a view like - Z_MARA_MVKE

Hi ,

I am facing an issue for the view - Z_MARA_MVKE which is collecting entry from Mara and MVKE table.

Now this view contains more than 36 lakhs entries for which this view is showing performance issue for us which is taking more than 10 mins time to execute . Can you please give me some suggestion how we can increase the performance of this view?

Moderator message: please use international units only, 36 lakhs = 3.6 million.

Edited by: Thomas Zloch on Sep 9, 2010 11:14 AM