How many rows will be sampled if the ORDERS table contains 5000 rows?
1064 To detect row migration or chaining in a table, use the ANALYZE TABLE command. The COMPUTE STATISTICS option will return exact statistics because it analyzes all of the rows in the table. The ESTIMATE STATISTICS option will compute statistics based on 1064 rows. You can use the ESTIMATE STATISTICS option with a sample integer or percent to specify the number or percentage of rows that are scanned.