SqlDbx
You are not logged in.
When CREATE script generates DDL for a partitioned table it does not correctly generates CREATE INDEX
create index ix1 on tbl1(col1)
NOLOGGING LOCAL
(partition part1 pctfree 10 initrans 2 maxtrans 255 NOLOGGING storage(...) tablespace tsp1
,partition part2 pctfree 10 initrans 2 maxtrans 255 NOLOGGING storage(...) tablespace tsp2
...
,partition part9 pctfree 10 initrans 2 maxtrans 255 NOLOGGING storage(...) tablespace tsp9
)
PARALLEL 8 ;
create index ix1 on tbl1(col1) tablespace tsp1 initial 20480 next 61440;
As you can see, script generated GLOBAL index instead of LOCAL one and this is a big difference!
Also, this index is LOGGING NOPARALLEL, i.e. directly opposite then original index.
Last edited by garbuya (2018-01-10 12:33:05)
Offline