IOT secondary index creation can't use parallel (30hours)
- From: Eagle Fan <eagle.f@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 18 Jan 2012 21:22:06 +0800
Hi:
I created IOT secondary index using parallel 4 online option on two
databases. One database is 10203 version and another one is 11202 version.
On 10203 version, the SQL finished in 20 minutes, but on 11202 version, it
used 30 hours. The two databases have same table/index structure and both
of them are about 100GB.
On 10203 database, it used PK index fast full scan with parallel 4 as
expected. But on 11202 database, it didn't use parallel index fast full
scan, it used single thread db file sequential read on PK index. That's why
it took 30 hours.
I don't know why on 11202 version, the secondary IOT index creation used
less effecient db file sequential read instead of index fast full scan.
Is there any way to make it faster?
The SQL is like this:
CREATE INDEX T_IDX2 ON T (
a,b,c)tablespace index01 parallel 4 ONLINE;
Thanks in advance.
--
Eagle Fan
--
//www.freelists.org/webpage/oracle-l
Other related posts:
