查看表的采样率

查看表的采样率

SELECT owner,
       table_name,
       num_rows,
       sample_size,
       round(sample_size / num_rows * 100) estimate_percent
  FROM DBA_TAB_STATISTICS
 WHERE owner='SCOTT' 
 AND table_name='T_STATS';