Disclaimer: I am, in all probability, paranoid about pushing a patch on a production server.

The patch alters the schema, by creating a new table (which is empty), and changes some stored procedures which do not run instantly when the patch is pushed. The altered stored procedure will not act upon already stored data but only new data that reaches the database.

Does creating an empty table result in any significant amount of downtime or not?

  • 3
    No, it does not. – LowlyDBA Feb 17 '15 at 15:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.