Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

3. If it is upgraded to Altibase version 6.3.1 or higher, PK or UNIQUE INDEX can be created as a global index.

 

# Example

Code Block
iSQL> CREATE TABLE REALSET_CONTENTS
2 (
3 CT_ID VARCHAR (32) NOT NULL,
4 CT_TYPE VARCHAR (2) NOT NULL,
5 CT_PATH VARCHAR (256) NOT NULL,
6 CT_URL VARCHAR (256) NOT NULL,
7 REG_DATE DATE NOT NULL,
8 FILE_NAME VARCHAR (256) NOT NULL,
9 STATUS VARCHAR (4) NOT NULL
10 )
11 PARTITION BY RANGE (REG_DATE)
12 (
13 PARTITION P_1 VALUES LESS THAN (to_date('2013-05-01', 'YYYY-MM-DD')),
14 PARTITION P_2 VALUES LESS THAN (to_date('2013-09-01', 'YYYY-MM-DD')),
15 PARTITION P_DEF VALUES DEFAULT
16 )
17 TABLESPACE SYS_TBS_DISK_DATA;
Create success.
iSQL> alter table REALSET_CONTENTS add primary key(CT_ID,REG_DATE);
[ERR-31283 : Unable to create a primary key or a unique key constraint in the local non-prefixed index.]

...

Reference

...

# Index type for the partitioned table

Class condition 1

Class condition 2

Class condition 3

Index type

Support/Not Supported

The index is partitioned.

index part key = table part key

index part key = index key

(Partitioned) Local prefixed Index

Supported

 

 

index part key != index key

(Partitioned) Local nonprefixed Index

Supported

 

index part key != table part key

index part key = index key

(Partitioned) Global prefixed Index

Not supported

 

 

index part key != index key

(Partitioned) Global nonprefixed Index

No Not supported

The index is not partitioned.

 

 

Nonpartitioned global index

Supported in version 6.3.1 or later

...