Re: A little baffled by "chained rows"....

> Finally, a subtler fix for the problem: if you are trying to fix up a bit
> of row migration or chaining, you don't necessarily want to have to move
> the entire multi-gigabyte table (or copy it, delete it, and re-insert).
You
> want, instead, just to home in on the offending rows. Therefore, having
> already populated the chained_rows table with the rowids of the offending
> rows:

Now that's a good tip! Very simple and effective solution which is very often overlooked (including by me ;)

Tanel. Received on Tue Aug 12 2003 - 03:00:56 CDT