What performs better – Expanding DB column or expanding db row? My benchmark test shows expanding DB column performs better, on the following machine configuration:
Processor: Intel® Pentium® 4; 2.66 GHz;
Memory: 960 RAM.
Operating System: Windows XP, Version 2002, Service Pack 2.
Expanding Columns
A table having 4 columns with nchar(10) data type with 20,112 rows, query executes:
SQL Server Execution Times: CPU time = 47 ms, elapsed time = 125 ms.
Scan count 1, logical reads 232, physical reads 0, read-ahead reads 0.
Expanding Rows
A table having 1 column with nchar(10) data type with 80,017 rows, query executes:
SQL Server Execution Times: CPU time = 63 ms, elapsed time = 253 ms.
Scan count 1, logical reads 301, physical reads 0, read-ahead reads 0.