Re: Creating multiple indexes
- From: Taral Desai <taral.desai@xxxxxxxxx>
- To: Laimutis.Nedzinskas@xxxxxx
- Date: Wed, 17 Nov 2010 09:24:38 -0600
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.
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Thanks & Regards,
Taral Desai
Other related posts:
