I have done an unthinkable and read the manual on tablespaces. And I have stumbled on something that I can not find an explanation for and hope that you guys can help me out here. here is what I found.

This topic can be found in: Administration Guide: Planning

If you need to drop and redefine a particular table often, you may want to define the table in its own table space, because it is more efficient to drop a DMS table space than it is to drop a table.

Question is:"Why is it faster to drop a table space with the table in it, then simply drop redefine a particular table?"

I know it got to be very simple, but I am drawing a blank on it.

Thank you in advance.

When we drop a table space, it will also drop all the tables as long as it does not have other related objects in other tablespaces(like data in one table space and indexes in another table spaces).

When we drop a table space, DB2 does not log all of the row and page deletions as it does for a drop table operation. Hence dropping a table space is much efficient than dropping a table.

Hope this helps.

Thanks,
Madhavi.

right, that I am aware of. I was just wondering if I was missing some other point.

Thank you.