Posted by serge on 10/01/97 11:41

Even when I restored the same db using a different db name and
different physical file names, I run my query, the first time it takes
8 seconds then 2, all with no 15 million reads!

The only common thing would be the logical file name which
I did not change everytime I restored this same db.

It's almost like everytime we restore a database, we should
immediately right after re-index it and update all the statistics?

I am sure now if I restore this same db on another SQL Server
Instance, I will keep getting 15 million reads until I update
the statistics of 1 single table. Then that SQL Server Instance
will never take 15 million reads if i drop the db and restore
it again. I don't know why.

• Next in forum: Re: How can I remove duplicate entries in a sql query?
• Prev in forum: Re: SQL Server: beginner: "Login failed for user 'sa'."
• Thread view: Re: Statistics IO logical reads sometimes 15 million and other times down to 90 thousand?

[Reply to this message]