Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> index node split autonomy

index node split autonomy

From: <ctcgag_at_hotmail.com>
Date: 25 May 2003 23:14:50 GMT
Message-ID: <20030525191450.694$U2@newsreader.com>


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 50GB
Received on Sun May 25 2003 - 18:14:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US