Ok, I like to gamble. Dave, I respectfully disagree.
If you...
ANALYZE TABLE HANKY.YO_MOMMA LIST CHAINED ROWS;
CREATE TABLE CHAIN_TEMP as
SELECT * from HANKY.YO_MOMMA
WHERE rowid in (SELECT head_rowid from CHAINED_ROWS
WHERE table_name = 'YO_MOMMA);
SELECT COUNT(*) FROM CHAIN_TEMP;
DELETE from HANKY.YO_MOMMA
WHERE rowid in (SELECT head_rowid from CHAINED_ROWS
WHERE table_name = 'YO_MOMMA);
INSERT into HANKY.YO_MOMMA
SELECT * from CHAIN_TEMP;
DROP table CHAIN_TEMP;
DELETE from CHAINED_ROWS
WHERE table_name = 'YO_MOMMA;
You will eliminate chained rows in this table.
Yes no?
Or did you mix up chained and migrated?
MH
I remember when this place was cool.