Re: leaf node splits

From: Dom Brooks <dombrooks_at_hotmail.com>
Date: Fri, 27 Jan 2012 18:03:34 +0000
Message-ID: <BLU0-SMTP276866F252677B1F92B68F6A18E0_at_phx.gbl>

Sorry - I'm just being really dim, which possibly doesn't translate effectively in this medium.

I've been waiting for the "Doh!"...

I just wasn't getting the different effect between the rollback on the 50:50 splits - ie the split remains but the new data is obviously rolled back.

Whereas with the 90:10s all the data was new data which when removed meant the blocks were empty and so ... back on the free list waiting for me to do it all again.

Cheers,
Dominic

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jan 27 2012 - 12:03:34 CST