huge time difference in a report execution

[philelmousse]

Hello,

I have a report which sometimes takes 2min to run and other time 30min with the same parameters.

What could be the cause ?

[zealkarthick]

This many be the cause of index in UR DB, try to defragment the index and check it. it will get reduce