【SQLServer】統計情報のサンプリング率一覧を出すSQL
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
--//統計情報サンプリング率一覧 SELECT OBJECT_NAME(dsp.object_id) , dsp.object_id , ss.name , dsp.last_updated , dsp.rows , dsp.rows_sampled , dsp.steps , dsp.unfiltered_rows , dsp.modification_counter , ROUND( (dsp.rows_sampled * 100 / dsp.rows) ,2) as [SamplingRate(%)] FROM sys.stats AS ss CROSS APPLY sys.dm_db_stats_properties(ss.object_id, ss.stats_id) AS dsp WHERE OBJECT_SCHEMA_NAME(dsp.object_id, DB_ID()) <> 'sys' Order by [SamplingRate(%)] |
