-
I am in process of creating partition table based on range.
If the key on the partition table is different then LOCAL Indexes, will it impact on performance?
i.e.
CREATE TABLE TEST
(c1 number,
c2 varchar2(20),
c3 varchar2(10),
c4 varchar2(10))
PARALLEL(DEGREE 4 INSTANCES 1)
PARTITION by range (c1,c2)
(
PARTITION T1 VALUES LESS THAN (100,’A’)
STORAGE(INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
FREELISTS 1
FREELIST GROUPS 1)
LOGGING,
…
)
CREATE INDEX TEST_IND on TEST(c1,c3,c2)
LOCAL (PARTITION T1
STORAGE(INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
FREELISTS 1
FREELIST GROUPS 1)
TABLESPACE TSIND LOGGING,
…
)
If table is created with PARALLEL DEGREE and INDEX is not, what will happen?
Thanks.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|