Skip Headers
Oracle® Database VLDB and Partitioning Guide
11g Release 1 (11.1)

B32024-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
PDF · Mobi · ePub

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