Closed sundy-li closed 9 months ago
Now execute sql:
echo "SELECT number, NTH_VALUE(number, 2) OVER (ORDER BY score DESC) FROM (select number::string number , number % 100 as score from numbers(300000000) ) ignore_result;" | bendsql
The CPU load just takes 0.1% instead of 100%.
Now execute sql:
The CPU load just takes 0.1% instead of 100%.