InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Does Table Partitioning Require User Defined Segments In Sybase? |
|
Answer» No. By design, each table is INTRINSICALLY assigned to one segment, called the default segment. When a table is partitioned, any partitions on that table are distributed among the DEVICES assigned to the default segment.In the example under “How Do I Create A Partitioned Table That Spans MULTIPLE Devices?”, the table SITS on a userdefined segment that spans three devices No. By design, each table is intrinsically assigned to one segment, called the default segment. When a table is partitioned, any partitions on that table are distributed among the devices assigned to the default segment.In the example under “How Do I Create A Partitioned Table That Spans Multiple Devices?”, the table sits on a userdefined segment that spans three devices |
|