Performance Rows in base table : ~62,000 Rows in pivot table : 5,000 Columns : 50 Sparseness : 25% (average columns per row) id attribute_name value | id attribute_001 attribute_002 ... attribute_050 -- -------------- ----- | -- ------------- ------------- ------------- 1 attribute_001 123 | 1 123 1 attribute_023 321 | 2 312 2 attribute_002 312 | 2 attribute_050 33 |