Reducing the amount of data requested requires partitioned tables, then querying the where based on the partition
@TernaryData
2 жыл бұрын
Definitely true, although be careful not to optimize prematurely - partitioning a tiny table can actually decrease performance. But as data and costs grow, partitioning with an appropriate key is essential.
@jimmyf.x.9526
2 жыл бұрын
Lol. Limit doesn't limit is so dirty. Every Db I worked with when use limit can reduce work needed from server. Thanks for the heads up!
@TernaryData
2 жыл бұрын
This is a side effect of using a columnar database that bites a lot of people coming from a relational database background. Incidentally, BigQuery has improved the performance of LIMIT since we posted this video.
Пікірлер: 6