Search code examples
db2db2-luw

TABLE vs TABLESPACE , what's the difference?


I want to know the difference between TABLE and a TABLESPACE in db2-luw.


Solution

  • The tablespace is where tables gets stored.

    It links the physical storage layer (files on disks) and the logical storage layer (tables, indexes).

    You can assign each table to a tablespace to control the physical storage layout (for example to put some tables on faster or more redundant disks, or to stripe tables across disks).