Re: leaf node splits

  • From: Dom Brooks <dombrooks@xxxxxxxxxxx>
  • To: "andy@xxxxxxxxxxxxxxx" <andy@xxxxxxxxxxxxxxx>
  • Date: Fri, 27 Jan 2012 18:03:34 +0000

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
--
//www.freelists.org/webpage/oracle-l


Other related posts: