Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: index node split autonomy
On Sun, 25 May 2003 23:14:50 +0000, ctcga wrote:
> But I'm curious about the analogous operations on
> indices. If indices never split blocks, it seems they could operate in
> pretty much the same way as tables.
Indices do split blocks. Indices are classic balanced B*trees of order N, working just like described in Knuth's "The Art of Computer Programming". Nothing fancy or unusual there.
-- Mladen Gogala Software is like sex, it is better when it is free. Linus TorvaldsReceived on Sun May 25 2003 - 21:16:32 CDT