News for hackers. Stuff that matters.
Re:Why is Snowflake so expensive by kolinko on Monday August 22, 2022 @12:30PM (#32553741)
in case of BigQuery it makes sense though - they use map reduce on distributed clusters, so there is no easy way to stop after 10 results are found
Re:Why is Snowflake so expensive by JimmyAustin on Monday August 22, 2022 @12:34PM (#32553795)
It's pretty easy to limit the number of results returned by each partition to by limited to 10, then have that further reduced to 10 total during the reduce step.