By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
The inline table valued funtion (itvf) fnNumbers returns bigint and can generate n of up to 4^16
Performance Summary |
---|
fnNumbers inserted 40x row counts (n=1,000) in 266 milliseconds |
SQL Server parse and compile time:
CPU time = 265 ms, elapsed time = 265 ms.
Table '#test_fnNumbers_row_counts__________________________________________________________________________________________0000000001FB'. Scan count 0, logical reads 40, physical reads 0, page server reads 0, read-ahead reads 0, page server read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob page server reads 0, lob read-ahead reads 0, lob page server read-ahead reads 0.
SQL Server Execution Times:
CPU time = 0 ms, elapsed time = 0 ms.
SQL Server Execution Times:
CPU time = 0 ms, elapsed time = 0 ms.
Performance Summary |
---|
fnTally inserted 40x row counts (n=1,000) in 2485 milliseconds |
SQL Server parse and compile time:
CPU time = 1453 ms, elapsed time = 2484 ms.
Table '#test_fnTally_row_counts____________________________________________________________________________________________0000000001FC'. Scan count 0, logical reads 40, physical reads 0, page server reads 0, read-ahead reads 0, page server read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob page server reads 0, lob read-ahead reads 0, lob page server read-ahead reads 0.
SQL Server Execution Times:
CPU time = 0 ms, elapsed time = 0 ms.
SQL Server Execution Times:
CPU time = 0 ms, elapsed time = 0 ms.