Re: Creating multiple indexes

From: Taral Desai <taral.desai_at_gmail.com>
Date: Wed, 17 Nov 2010 09:24:38 -0600
Message-ID: <AANLkTik01PkxiHXcYHRPR8WX86tw6_z55jq-AODDHVQv_at_mail.gmail.com>

Checkout DBMS_INDEX_UTL package.

http://psoug.org/reference/dbms_index_utl.html

<http://psoug.org/reference/dbms_index_utl.html>I didn't tried it but you can try and let us know if this works.

• DBMS_INDEX_UTL*

On Wed, Nov 17, 2010 at 12:18 AM, <Laimutis.Nedzinskas_at_seb.lt> wrote:

> >I'm trying to find the reason why there isn't a
> mechanism to create multiple indexes at the same time - a "create
> indexes" statement or similar.
>
> Some optimizations can possibly be done.
>
> >Each create index needs to scan through every row in the table to form
> the index.
> >i.e. 10 indexes = 10 full scans.
>
> b-tree initial construction requires sorting
> (http://en.wikipedia.org/wiki/B-tree#Initial_construction)
> Let's use a merge-sort algorithm (http://en.wikipedia.org/wiki/Merge_sort
> ),
> ok?
> Merge algorithm does scan all rows but it also does more than that.
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Thanks & Regards,
Taral Desai

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Nov 17 2010 - 09:24:38 CST