What is the proper way to drop a large table and how to estimate the time needed for such action?
This is a question about a possible issue --
we have a large table (~800GB) in our primary PRD database (core business database) that has a BLOB object in it. Recently the application functionality was changed and this table is not used any more. We would like to drop this table from PRD and reclaim the storage.
Questions --
1) Anyway to estimate how long it might take to drop this table?
2) Any possibilities of getting into a contention/locking issue while dropping this table?
3) Anything else we need to be prepared for?
Facts
====
1) This is our top PRD database (oltp) needing 24x7 availability
we have a large table (~800GB) in our primary PRD database (core business database) that has a BLOB object in it. Recently the application functionality was changed and this table is not used any more. We would like to drop this table from PRD and reclaim the storage.
Questions --
1) Anyway to estimate how long it might take to drop this table?
2) Any possibilities of getting into a contention/locking issue while dropping this table?
3) Anything else we need to be prepared for?
Facts
====
1) This is our top PRD database (oltp) needing 24x7 availability
0