Query takes long time to load

[Former Member]

Hello experts,

My users have queries on a MultiProvider. Today, the queries take a long time to load. When they want to put a filter on it, the selection pop-up takes a long time to show the possible selections.

Is there any way to find out what causes the long wait time? And what can I do about it, to optimize it?

Thanks in advance.

[Former Member · Accepted solution]

Hi Erica,

Please check load on system(how many users are logged in..?)

Please check : [Checklist for Query Performance|http://sapbwneelam.blogspot.com/2007/10/checklist-for-query-performance.html] some tips for query performance.

Hope it Helps

Srini

[Former Member]

I updated the ODS statistics in db20, now the query is running smoothly.