Re: Creating multiple indexes
- From: Laimutis.Nedzinskas@xxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 17 Nov 2010 08:18:43 +0200
>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
Other related posts:
