In Sybase does table Partitioning needs user-defined segment

In Sybase does table Partitioning needs user-defined segments?

E

Expert

Verified

No, it doesn’t need. By design, all tables are intrinsically assigned to one segment, termed as the default segment. As a table is partitioned, any partitions on such table are distributed in between the devices assigned to the default segment.

In the illustration under "How do I make a partitioned table such spans multiple devices?” the table sits upon a user-defined segment which spans three devices.

   Related Questions in Database Management System

©TutorsGlobe All rights reserved 2022-2023.