In DB2, it seems there is a strong separation between what a database is and what a tablespace is. Where as in MySQL and MS SQL Server tablespace and database seemed to be used synonymously.
What are the differences, if any?
1
-
3This question appears to be off-topic because it's about inner workings of RDBMSs. It's more suitable for dba.stackexchange.com.Tulains Córdova– Tulains Córdova2014-08-02 04:06:57 +00:00Commented Aug 2, 2014 at 4:06
Add a comment
|
1 Answer
In DB2 and Oracle, tablespace is roughly the child 'containers' within a database. You can, for example, organize your huge tables to be created on a specific tablespace, for managing the disk storage.
In MS SQL server there is no concept of tablespaces AFAIK. It uses file groups for the purpose of organizing storage and there is no one-to-one correlation with the tablespace concept.
