Tablesample Picks Rows
3 points by surprisetalk
TABLESAMPLE functionality in databases allows for sampling of addresses rather than individual rows. SYSTEM samples are bundled, while BERNOULLI samples may show variability after an UPDATE, although they can be made repeatable with a hashed key, ensuring consistent row selection across queries.