What does the SQL:2003 TABLESAMPLE clause provide?

Explanation

The SQL:2003 TABLESAMPLE clause provides an approximate random sample of table rows using SYSTEM or BERNOULLI sampling without a full scan. This allows for efficient sampling without the need to scan the entire table.

Key points

TABLESAMPLE clause in SQL:2003 provides random sampling of table rows
SYSTEM and BERNOULLI are the two sampling methods available
Sampling is approximate, not exact
Avoids the need for a full table scan

Ready to go further?

Start full exam Practice more questions