admin管理员组文章数量:1613377
Similar to Oracle database, DB2 also has the conception of table space. A table space is the storage structure containing tables, indexes, larger objects/long data such as LOB Object, therefore the table space orginze these datas in database to group them into logical structure.
In physically, the table space contains some storage area, such as file, raw device, NAS or other storage. In db2 we name them container. that is same as the datafile in Oracle database, obviously the datafile is not only specify the file and the container is also. And the container's meaning is more exactly than datafile.
What can table space offer?
Table space make the storage management more easily and regular ly. Tables, Indexes and Large Object/Long Data all are the logical kind of objects. They all store the file, device or othre storages. By table space we can orgnize them into differenet group. And we can store the tables, indexes and so on which are accessed frequently on the fast device. Constrarily the historical data which is retrieved ocassionally on the slower or less expensive device.
本文标签: fundamentalTablespaceORACLEadditional
版权声明:本文标题:DB2 fundamental - Tablespace (additional the different between Oracle's and Its) 内容由热心网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:https://www.elefans.com/dianzi/1728643738a1167427.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
发表评论