> By the other hand, when I do a backup-restore, the same query runs whithout any problem, the report takes few second to show up in the preview tool I'm using...
>
> If it was a problem with bad plan selection, wouldn't it persist after the backup-restore?
>
> THANKS!!!!
>
> -s
>

That could be by index statistics is not updated. Try to update them. :)

Regards,