re: Knowing about 'Forwarded Records' can help diagnose hard to find performance issues.

Herbg — Tue, 27 May 2008 22:50:57 GMT

Table A

2 indexes, neither was a clustered index

In a 22 Million row table, with address1,2,3 each varchar(50), data1 and data 2 each varchar (100)- all 5 columns set to NULL.

After all 5 columns were updated, required over 8 hours just to "select * into" another table, tableB from TableA.

However, "Select into TableC " from Table B was less than 5 minutes.

TableA has forward records 7,548,908 while TableB had none.

Thanks for the article.