What does the SQL:2003 TABLESAMPLE clause do?

Advanced SQL Developer Hard

Advanced SQL Developer — Hard

What does the SQL:2003 TABLESAMPLE clause do?

Key points

  • TABLESAMPLE clause provides random sampling without full table scan
  • Options include SYSTEM (block-level) or BERNOULLI (row-level) sampling
  • Useful for analyzing large datasets quickly

Ready to go further?

Related questions