ANALYZE TABLES [ { FROM | IN } database_name ] COMPUTE STATISTICS [ NOSCAN ]ANALYZE TABLE table_identifier[ PARTITION ( partition_col_name [ = partition_col_val ] [ , ... ] ) ]COMPUTE STATISTICS [ NOSCAN | FOR COLUMNS col [ , ... ] | FOR ALL COLUMNS ]
database_name：統計情報を計算する必要があるテーブルが存在するデータベース。table_identifier：統計情報を計算する必要があるテーブル名。partition_col_name：統計情報を計算する必要があるパーティション列名。partition_col_value：統計情報を計算する必要があるパーティション列の値。ANALYZE TABLE students COMPUTE STATISTICSANALYZE TABLE students COMPUTE STATISTICS FOR COLUMNS nameANALYZE TABLE db.students COMPUTE STATISTICS FOR COLUMNS nameANALYZE TABLE students COMPUTE STATISTICS NOSCANANALYZE TABLE students COMPUTE STATISTICS FOR all COLUMNSANALYZE TABLE db.students COMPUTE STATISTICS FOR all COLUMNSANALYZE TABLE students PARTITION (student_id) COMPUTE STATISTICSANALYZE TABLE students PARTITION (student_id = 111111) COMPUTE STATISTICSANALYZE TABLE db.students PARTITION (student_id = 111111, name = 'test') COMPUTE STATISTICS FOR all COLUMNSANALYZE TABLES COMPUTE STATISTICSANALYZE TABLES COMPUTE STATISTICS NOSCANANALYZE TABLES from school_db COMPUTE STATISTICS NOSCANANALYZE TABLES IN school_db COMPUTE STATISTICS NOSCAN
フィードバック