You can decide how to allocate the tables to various segments based upon your system requirements. For example, you decide to relocate all sensitive tables that require daily backup to a separate segment so that you can take that segment offline and back it up more frequently than other data. Based on these requirements, it can be necessary to change the segment number of a table.
When user tables are defined, the definitions are stored on segment 0 and the table data is stored on the default TDS segment as specified in the creator’s user profile. Users of the table do not need to know how or where it is physically stored.
