Our BW reports are slow sometimes, and may be running fast some other time (with same parameters). For example, same report ran fast all day yesterday (20-40 seconds). This morning at 9 it took 5 minutes. But at 4 PM it ran in 30 seconds.
Nothing glaring is poping up at the system level for blaming. what should we check at database level? Does someone have any other suggestion what might be the problem?