For 'big' databases, maps big tables to their own file groups |
In big databases we only put core objects in the primary file group. Other objects are grouped into separate file groups. For really big files, the indices are put in even different groups. This table is truncated in the Task databases. |
name | type | length | unit | ucd | description |
tableName | varchar | 128 | name of table or index | ||
tableFileGroup | varchar | 100 | name of filegroup | ||
indexFileGroup | varchar | 100 | name of the index filegroup | ||
comment | varchar | 4000 | explanation |