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 10x row counts (n=10,000) in 63 milliseconds |
SQL Server parse and compile time:
CPU time = 46 ms, elapsed time = 46 ms.
Table '#test_fnNumbers_row_counts__________________________________________________________________________________________0000000001EB'. Scan count 0, logical reads 10, 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 = 16 ms, elapsed time = 15 ms.
SQL Server Execution Times:
CPU time = 0 ms, elapsed time = 0 ms.
Performance Summary |
---|
fnTally inserted 10x row counts (n=10,000) in 281 milliseconds |
SQL Server parse and compile time:
CPU time = 281 ms, elapsed time = 281 ms.
Table '#test_fnTally_row_counts____________________________________________________________________________________________0000000001EC'. Scan count 0, logical reads 10, 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.