Re: Creating multiple indexes

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@xxxxxx> 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

Other related posts: