I refreshed one production report yesterday. It took only 25 seconds. But today it is taking more than 45 minutes…What can be the possible issues ?
How should I proceed to fix it ?
Developer_Designer (BOB member since 2009-08-09)
Hi,
Definitely talk to your DBA. Ask him/her what the load on the database is, if any new large volume of data has been loaded into the database recently, if any new statistics of tables/indexes have been collected, if any indexes have been dropped, … DBAs should check the performance of the query and tell you what’s happening.
Marek Chladny 
(BOB member since 2003-11-27)