I want to know the difference between TABLE
and a TABLESPACE
in db2-luw
.
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).