Sybase Question:
Download Questions PDF

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 user-defined segment that spans three devices.

Download Sybase Interview Questions And Answers PDF

Previous QuestionNext Question
We have lost the sa password, what can we do?How Do I Choose Which Tables To Partition in Sybase?