|
|
|
|
|
|
by mike_r_parsons
1002 days ago
|
|
|
How does this compare to the following? create table testInt(num Integer);
WITH n(n) AS(SELECT 1 UNION ALL SELECT n+1 FROM n WHERE n < 1000000) insert into testInt select n from n; On my machine - Mac Mini 3 GHz Dual-Core Intel Core i7 16 GB 1600 MHz DDR3 this takes
Run Time: real 0.362 user 0.357236 sys 0.004530 |
|
|