What Is Secondary Index?

what is secondary index?

IOT secondary index creation can't use parallel (30hours)

At first, I suspect it's related to overflow segment, but seems it's not.
I created same small IOT tables on both databases and run the secondary
index creation sql again.

On 10203 database, it used parallel index fast scan read but on 11202
database, it still used single thread db file sequential read.

Thanks.

On Wed, Jan 18, 2012 at 9:22 PM, Eagle Fan
Elementary and secondary schools: State Market Index
Learn more
BizMiner

> 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.
Wole Soyinka: A Bibliography of Primary and Secondary Sources (Bibliographies and Indexes in Afro-American and African Studies)
Learn more
James Gibbs 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.

These are our most popular posts: what is secondary index?

SAP Technical blog: Function Modules for Secondary Indexes in ...

The primary key fields are key fields of the table and point to non key fields. The secondary indexes are non key fields in table. DD DROP INDEX - Deletes the index of the table. DD CREATE INDEX - Create primary and secondary index ... read more

SEO: What Your Website Absolutely Needs

By using simple links to your alternative content, a link to your humour page can get folks where they want to go, and then you can write your humour page as a secondary index optimized toward a humor theme. In the end ... read more

Re: logging disjoint sets of commits in a single command -- Git

I have it in mind to build a secondary index (maintained externally) so that I can supply these git commands with precise lists of revisions for much faster response times. Thanks, guys! -- To unsubscribe from this list: send the ... read more

tweaking for faster oracle: Re: IOT secondary index creation cant ...

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, ... read more

notebook

2012年2月2日木曜日

What Is Secondary Index?