If a database is read-only, does the auto update/create statistics still work? I'm guessing read-only is really read-only, but I'm hoping SQL sever makes an exception with these two settings.
Given the data cannot change then in theory there is no reason to update statistics. I suppose you could imagine Auto-adding working to better optimise query plans, but I doubt its going to happen.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply