Partitions (IQ)

A partition is a physical division of the contents of a database table, created to improve manageability and performance.

You can create as many partitions as necessary in a table.

Note: If you associate a table with a lifecycle (see Lifecycles (PDM)), PowerDesigner will delete all existing table partitions in order to create the necessary partitions to move data between lifecycle phases.

Creating a Partition
You create partitions on the Partitions tab of a table using the Insert Row and Add a Row tools.
Partition Properties
To view or edit a partition's properties, double-click its Browser or list entry. The property sheet tabs and fields listed here are those available by default, before any customization of the interface by you or an administrator.

Parent topic: Sybase IQ

Created July 21, 2011. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com