Defining a Data Group
A data group - or tablespace - is a group, in the same physical pages of the database, of the rows of several tables to optimize queries, joints in particular. Example: Tablespace in DB2, Cluster in Oracle etc.
To define data groups in the database:
1. Open the database properties dialog box.
2. Click the drop-down list then Components.
3. The Data groups section displays the list of data groups
4. Click the New button.
5. In the dialog box that opens, indicate the Name of the data group.
6. Click OK.
Then open the properties window of the data group to define the tables and indexes that it includes.
To specify the tables and indexes included in the data group:
1. Select the data group and click Properties.
The data group properties dialog box appears.
2. Click the drop-down list then Tables.
3. Click the Connect button.
4. In the list of database tables presented, select the tables to be included.
Click Disconnect to remove a table from the list in the case of error.5. Carry out the same operations for the indexes of the data group.
6. Click OK.