Extents in Clustered Tables (17)

Clustered tables store information in the data segment created for the cluster.
Therefore, if you drop one table in a cluster, the data segment remains for the other
tables in the cluster, and no extents are deallocated. You can also truncate clusters
(except for hash clusters) to free extents.

在cluster中删除一张表, 数据段还是保留给其他在该cluster中的表 , 除了hash cluster , 可以用truncate clusters来使extents free.

[@more@]
请使用浏览器的分享功能分享到微信等