Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> index node split autonomy
Many of the concurrency/consistency concepts are demonstrated in the Oracle
docs with simple examples on tables, where the process has to reach into
the undo to obtain a read-consistent view. I think I more or less
understand this. 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. But then they wouldn't be much good as
indices, either.
If an DML statement causes a index block to split, and then that statement rolls back, is the split also rolled back, or does it persist?
Xho
-- -------------------- http://NewsReader.Com/ -------------------- Usenet Newsgroup Service New Rate! $9.95/Month 50GBReceived on Sun May 25 2003 - 18:14:50 CDT
![]() |
![]() |