Re: question about rollback and redo

The rollback record for an index entry is the index entry plus the same overhead
of about 80 bytes.

The redo record is then two change vectors, one which is the 'purge leaf entry' from the index block change, and one which is the 'restore leaf entry' from the rollback block. Both records hold the index entry, plus
the usual change vector overheads.

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person
  who can answer the questions, but the
  person who can question the answers -- T. Schick Jr


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html

____Finland__September 22nd - 24th
____Norway___September 25th - 26th
____UK_______December (UKOUG conference)

Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
____USA__October
____UK___November


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


"Ryan" <rgaffuri_at_cox.net> wrote in message
news:Nd_ab.217$0Z5.180_at_lakeread03...


> how much does redo and rollback go up if you have indexes on the

tables when


> you do deletes? I know they go up when you do inserts and updates?

>

> aside from the additional work to manage the indexes.

>

>