<< Click to Display Table of Contents >>

Table Partitions

Top Previous Next

The upper part of the window shows the partition type and detail information about each partition of the current table:

Partition number

Partition name

Tablespace

High Value

High value length

% Free

% Used

Ini Trans

Max Trans

Initial Extent

Next Extent

Min Extent

Max Extent

%Increase

Freelists

Freelist Groups

Logging

Num Rows

Blocks

Empty Blocks

Avg Space

Chn Count

Avg Row Len

Sample Size

Last Analyzed

Buffer Pool

The following context operations are available:

CopySQL

Copy to clipboard

Copies partition name to the clipboard

 

Add

Adds a new partition to the table.

07_Drop

Drop

Drops the partition.

Attention: this means that all data in the partition will be deleted.

 

Truncate

Truncates partition, i.e. deletes the entire partition contents using the TRUNCATE statement.

05_Properties

Rename

Allows you to rename the partition.

 

Analyze

Gathers statistics

 

Grid View

For more information, see object window