Try running sp_updatestats in the production db.
Andrew J. Kelly
SQL Server MVP
"Arianna" <ariannaduoactionlabs.it> wrote in message
> I execute a sp that use 40 tables and other sp.
> If I execute this sp in the production db I have at
> execution time the 40 s.
> If I backup and restore the db in the same server but with
> an other db name I have execution time the 40 s, but if I
> execute the same sp the next day the execution time is 6-
> 10s. After the execution time is 6-10s.
> The execution time in the production db is everytime 40s.
> In the night the only job is the backup the production db.
> Why I have this problem?
> Thank you very much.