1. vna_mhars New Member

   Hi,
   Can I use the database while full scan in update statistics is running?
   Thanks
   

   vna_mhars, Feb 16, 2011

   #2
2. Luis Martin Moderator

   Welcome to the forums!.
   I don't recommend to do that. Schedule a job in a windows time.
   About your question: yes.
   

   Luis Martin, Feb 17, 2011

   #3
3. satya Moderator

   Welcome to the forums.
   It depends on how frequently and how many tables & their rowcount are involved in this update statistics task.
   By default there will be shared locks applied which update statistics is running.
   

   satya, Feb 17, 2011

   #4

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in