Re: Index on Partition Table
- From: "Jaromir D.B. Nemec" <jaromir@xxxxxxxxxxxx>
- To: <Jacques.Kilchoer@xxxxxxxxx>, <mdinh@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 13 Jun 2010 12:11:52 +0200
Hello,
> If you don't specify GLOBAL, then a local partitioned index will be created.
I'd formulate it as follows
If you specify LOCAL instead of GLOBAL, then a local partitioned index will be
created.
I was not able to verify it in the documentation, but test (10.2.0.3) shows no
difference between the options:
ALTER TABLE fct ADD CONSTRAINT fct_pk PRIMARY KEY (key) USING INDEX;
and
ALTER TABLE fct ADD CONSTRAINT fct_pk PRIMARY KEY (key) USING INDEX GLOBAL;
In both cases a nonpartitioned index is created.
The difference start by adding the global index properties such as
ALTER TABLE fct ADD CONSTRAINT fct_pk PRIMARY KEY (key) USING INDEX GLOBAL
partition by hash (key) partitions 2
In this case a global partitioned index is created.
Regards,
Jaromir
Other related posts:
