Index

A C D E F G H I J L M N O P R S T U V

A

ADD PARTITION clause, 3.2.2.1

ADD SUBPARTITION clause, 3.2.2.5.2, 3.2.2.6.2, 3.2.2.7.2

ALTER INDEX statement

for maintaining partitioned indexes, 3.2

partition attributes, 4.3.7

ALTER TABLE

MODIFY DEFAULT ATTRIBUTES FOR PARTITION clause, 3.2.7.2, 3.2.7.3

ALTER TABLE statement

for maintaining partitions, 3.2

MODIFY DEFAULT ATTRIBUTES clause, 3.2.7.1

C

clusters

cannot be partitioned, 1

indexes on

cannot be partitioned, 1

COALESCE PARTITION clause, 3.2.3.1

composite list-hash partitioning, 2.3.2.5

composite list-list partitioning, 2.3.2.6

composite list-range partitioning, 2.3.2.4

composite partitioning, 2.3.2, 2.3.2

default partition, 3.1.6.2

interval-hash, 3.1.6.5.1

interval-list, 3.1.6.5.2

interval-range, 3.1.6.5.3

list-hash, 3.1.6.4.1

list-list, 3.1.6.4.2

list-range, 3.1.6.4.3

range-hash, 3.1.6.1

range-list, 3.1.6.2

range-range, 3.1.6.3, 3.1.6.3

subpartition template, modifying, 3.2.11

composite range-hash partitioning, 2.3.2.2

composite range-list partitioning, 2.3.2.3

composite range-range partitioning, 2.3.2.1

CREATE INDEX statement

partition attributes, 4.3.7

partitioned indexes, 3.1.1.2

CREATE TABLE statement

creating partitioned tables, 3.1.1

D

data

partitioning, 6

data segment compression

bitmap indexes, 4.4.1

partitioning, 4.4

data warehouse

partitioned tables, 4.5.1

DEFAULT keyword

list partitioning, 3.1.4

default partitions, 3.1.4

default subpartition, 3.1.6.2

DISABLE ROW MOVEMENT clause, 3.1

DROP PARTITION clause, 3.2.4.1

dropping partitioned tables, 3.3

DSS database

partitioning indexes, 4.3.6

E

ENABLE ROW MOVEMENT clause, 3.1, 3.1.1.1

equipartitioning

examples, 4.3.1.1

local indexes, 4.3.1

EXCHANGE PARTITION clause, 3.2.5.1, 3.2.5.7, 3.2.5.8, 3.2.5.9, 3.2.5.10, 3.2.6

EXCHANGE SUBPARTITION clause, 3.2.5.6

F

FOR PARTITION clause, 3.2.8.1

full partition-wise joins, 4.2.1

G

global indexes

partitioning, 4.3.2

managing partitions, 4.3.2.2

summary of index types, 4.3.3

global partitioned indexes

maintenance, 2.5.2.3

H

hash partitioning, 2.3.1.2

creating tables using, 3.1.3

index-organized tables, 3.1.12.2, 3.1.12.3

multicolumn partitioning keys, 3.1.8

historical tables

moving time window, 3.4

I

indexes

cluster

cannot be partitioned, 1

global partitioned indexes, 4.3.2

managing partitions, 4.3.2.2

local indexes, 4.3.1

partitioning, 4.3.6

partitions, 1.1, 4.3

updating global indexes, 3.2.1

index-organized tables

partitioning, 3.1, 3.1.12

partitioning secondary indexes, 3.1.12.1

interval partitioned tables

dropping partitions, 3.2.4.2

interval partitioning, 2.4.1.1

creating tables using, 3.1.2

performance considerations, 4.5.1

interval-hash partitioning

creating tables using, 3.1.6.5.1

subpartitioning template, 3.1.7.1

interval-list partitioning

creating tables using, 3.1.6.5.2

subpartitioning template, 3.1.7.2

interval-range partitioning

creating tables using, 3.1.6.5.3

J

joins

full partition-wise, 4.2.1

partial partition-wise, 4.2.2

partition-wise, 4.2

L

list partitioning, 2.3.1.3

adding values to value list, 3.2.9

creating tables using, 3.1.4

DEFAULT keyword, 3.1.4

dropping values from value-list, 3.2.10

list-hash partitioning

creating tables using, 3.1.6.4.1

subpartitioning template, 3.1.7.1

list-list partitioning

creating tables using, 3.1.6.4.2

subpartitioning template, 3.1.7.2

list-range partitioning

creating tables using, 3.1.6.4.3

local indexes, 4.3.1, 4.3.3

equipartitioning, 4.3.1

M

materialized views

partitioned, 1

MODIFY DEFAULT ATTRIBUTES clause, 3.2.8.1

using for partitioned tables, 3.2.7.1

MODIFY DEFAULT ATTRIBUTES FOR PARTITION clause

of ALTER TABLE, 3.2.7.2, 3.2.7.3

MODIFY PARTITION clause, 3.2.8.1, 3.2.8.2, 3.2.12, 3.2.14.2.2

MODIFY SUBPARTITION clause, 3.2.8.3

MOVE PARTITION clause, 3.2.8, 3.2.12

MOVE SUBPARTITION clause, 3.2.8, 3.2.12.2

N

nonprefixed indexes, 2.5.1, 4.3.1.2, 4.3.4

global partitioned indexes, 4.3.2.1

O

OLTP database

partitioning indexes, 4.3.6

optimization

partition pruning

indexes, 4.3.5

partitioned indexes, 4.3.5

P

PARTITION BY HASH clause, 3.1.3

PARTITION BY LIST clause, 3.1.4

PARTITION BY RANGE clause, 3.1.1

for composite-partitioned tables, 3.1.6

PARTITION BY REFERENCE clause, 3.1.5

PARTITION clause

for composite-partitioned tables, 3.1.6

for hash partitions, 3.1.3

for list partitions, 3.1.4

for range partitions, 3.1.1

partition pruning, 4.1

dynamic, 4.1.4

static, 4.1.3

partitioned indexes, 3

adding partitions, 3.2.2.9

creating local index on composite partitioned table, 3.1.6.1

creating local index on hash partitioned table, 3.1.3.1

creating range partitions, 3.1.1.2

dropping partitions, 3.2.4.3

maintenance operations, 3.2

maintenance operations, table of, 3.2

modifying partition default attributes, 3.2.7.3

modifying real attributes of partitions, 3.2.8.4

moving partitions, 3.2.12.3

rebuilding index partitions, 3.2.14

renaming index partitions/subpartitions, 3.2.15.3

secondary indexes on index-organized tables, 3.1.12.1

splitting partitions, 3.2.16.7

partitioned tables, 3

adding partitions, 3.2.2

adding subpartitions, 3.2.2.5.2, 3.2.2.6.2, 3.2.2.7.2

coalescing partitions, 3.2.3

creating hash partitions, 3.1.3

creating interval partitions, 3.1.2

creating interval-hash partitions, 3.1.6.5.1

creating interval-list partitions, 3.1.6.5.2

creating interval-range partitions, 3.1.6.5.3

creating list partitions, 3.1.4

creating list-hash partitions, 3.1.6.4.1

creating list-list partitions, 3.1.6.4.2

creating list-range partitions, 3.1.6.4.3

creating range partitions, 3.1.1, 3.1.1.2

creating range-hash partitions, 3.1.6.1

creating range-list partitions, 3.1.6.2

creating range-range partitions, 3.1.6.3

creating reference partitions, 3.1.5

data warehouses, 4.5.1

DISABLE ROW MOVEMENT, 3.1

dropping, 3.3

dropping partitions, 3.2.4

ENABLE ROW MOVEMENT, 3.1

exchanging partitions, 3.2.5

exchanging subpartitions, 3.2.5.6, 3.2.5.8, 3.2.5.10

index-organized tables, 3.1, 3.1.12.1, 3.1.12.2, 3.1.12.3

maintenance operations, 3.2

marking indexes UNUSABLE, 3.2.2.2, 3.2.3, 3.2.4.1, 3.2.4.3, 3.2.5, 3.2.6, 3.2.8.1, 3.2.8.1, 3.2.8.2, 3.2.12, 3.2.16, 3.2.17

merging partitions, 3.2.6

modifying default attributes, 3.2.7

modifying real attributes of partitions, 3.2.8

modifying real attributes of subpartitions, 3.2.8.3

moving partitions, 3.2.12

moving subpartitions, 3.2.12.2

multicolumn partitioning keys, 3.1.8

rebuilding index partitions, 3.2.14

redefining partitions online, 3.2.13

renaming partitions, 3.2.15

renaming subpartitions, 3.2.15.2

splitting partitions, 3.2.16

truncating partitions, 3.2.17

truncating subpartitions, 3.2.17.2

updating global indexes automatically, 3.2.1

partitioning

composite, 2.3.2, 2.3.2

composite list-hash, 2.3.2.5

composite list-list, 2.3.2.6

composite list-range, 2.3.2.4

composite range-hash, 2.3.2.2

composite range-list, 2.3.2.3

composite range-range, 2.3.2.1

creating partitions, 3.1

data, 6

data segment compression, 4.4

bitmap indexes, 4.4.1

default partition, 3.1.4

default subpartition, 3.1.6.2

hash, 2.3.1.2

index-organized tables, 3.1, 3.1.12.1, 3.1.12.2, 3.1.12.3

interval, 2.4.1.1

interval-hash, 3.1.6.5.1

interval-list, 3.1.6.5.2

interval-range, 3.1.6.5.3

list, 2.3.1.3, 3.2.9, 3.2.10

list-hash, 3.1.6.4.1

list-list, 3.1.6.4.2

list-range, 3.1.6.4.3

maintaining partitions, 3.2

range, 2.3.1.1

range-hash, 3.1.6.1

range-list, 3.1.6.2

range-range, 3.1.6.3, 3.1.6.3

reference, 2.4.2.1

subpartition templates, 3.1.7

system, 2.1.4

virtual columns, 2.4.2.2

partitions, 1.1

equipartitioning

examples, 4.3.1.1

local indexes, 4.3.1

global indexes, 4.3.2

local indexes, 4.3.1

materialized views, 1

nonprefixed indexes, 2.5.1, 4.3.1.2, 4.3.4

partition pruning

indexes, 4.3.5

partitioning indexes, 4.3, 4.3.6

physical attributes, 4.3.7

prefixed indexes, 4.3.1.1

pruning, 4.1

PARTITIONS clause

for hash partitions, 3.1.3

partition-wise joins, 4.2

full, 4.2.1

partial, 4.2.2

performance

prefixed and nonprefixed indexes, 4.3.5

predicates

partition pruning

indexes, 4.3.5

prefixed indexes, 4.3.1.1, 4.3.3

pruning

partition, 4.1

pruning partitions

indexes, 4.3.5

R

range partitioning, 2.3.1.1

creating tables using, 3.1.1

index-organized tables, 3.1.12.1

multicolumn partitioning keys, 3.1.8

performance considerations, 4.5.1

range-hash partitioning

creating tables using, 3.1.6.1

subpartitioning template, 3.1.7.1

range-list partitioning

creating tables using, 3.1.6.2

subpartitioning template, 3.1.7.2

range-range partitioning

creating tables using, 3.1.6.3, 3.1.6.3

REBUILD PARTITION clause, 3.2.12.3, 3.2.14.2.1, 3.2.14.2.1

REBUILD UNUSABLE LOCAL INDEXES clause, 3.2.14.2.2

reference partitioning, 2.4.2.1

creating tables using, 3.1.5

RENAME PARTITION clause, 3.2.15.1, 3.2.15.3.1

RENAME SUBPARTITION clause, 3.2.15.2

row movement clause for partitioned tables, 3.1

S

SET INTERVAL clause, 3.2.2.4

SPLIT PARTITION clause, 3.2.2.1, 3.2.16

storage

index partitions, 4.3.7

STORE IN clause, 3.1.6.1

SUBPARTITION BY HASH clause

for composite-partitioned tables, 3.1.6

SUBPARTITION clause, 3.2.2.5.1, 3.2.2.6.1, 3.2.2.7.1, 3.2.16.4

for composite-partitioned tables, 3.1.6

subpartition templates, 3.1.7

modifying, 3.2.11

SUBPARTITIONS clause, 3.2.2.5.1, 3.2.16.4

for composite-partitioned tables, 3.1.6

system partitioning, 2.1.4

T

tables

index-organized, partitioning, 3.1.12

moving time windows in historical, 3.4

partitions, 1.1

TRUNCATE PARTITION clause, 3.2.17, 3.2.17, 3.2.17.1, 3.2.17.1.1, 3.2.17.1.1

TRUNCATE SUBPARTITION clause, 3.2.17.2

U

UPDATE GLOBAL INDEX clause

of ALTER TABLE, 3.2.1

V

virtual column-based partitioning, 2.4.2.2