要解决此问题,请使用ALTER TABLE … REBUILD PARTITION 和 ALTER TABLE … ANALYZE PARTITION。 未分区的表不支持ANALYZE PARTITION、CHECK PARTITION、OPTIMIZE PARTITION和REPAIR PARTITION选项。 ●REMOVE PARTITIONING使您能够删除表的分区,而不会影响表或其数据。此选项可以与其他ALTER TABLE选项(如用于添加、删除或重命...
| REORGANIZE PARTITION [partition_namesINTO(partition_definitions)] | ANALYZE PARTITION partition_names | CHECK PARTITION partition_names | OPTIMIZE PARTITION partition_names | REBUILD PARTITION partition_names | REPAIR PARTITION partition_names | EXCHANGE PARTITION partition_name WITH TABLE tbl_name | REM...
ALTER TABLE 联合 DISCARD … PARTITION … TABLESPACE 或 IMPORT … PARTITION … TABLESPACE不创建任何临时表或临时分区文件。 ALTER TABLE 联合 ADD PARTITION、DROP PARTITION、COALESCE PARTITION、REBUILD PARTITION 或 REORGANIZE PARTITION 不会创建临时表(与NDB表一起使用时除外);但是,这些操作可以创建临时分区文件。
| [ REBUILD ] UNUSABLE LOCAL INDEXES | { ADD | DROP } VALUES ( list_values ) | read_only_clause | indexing_clause } move_table_partition: MOVE partition_extended_name [ MAPPING TABLE ] [ table_partition_description ] [ filter_condition] [ update_index_clauses ] [ parallel_clause ] [...
ALTER TABLE은 열과 제약 조건을 변경, 추가 또는 삭제하여 테이블 정의를 수정합니다. ALTER TABLE은 파티션을 다시 할당 및 다시 빌드하거나 제약 조건과 트
AlterTableTruncatePartition AlterTablePartition AlterTableEnableKeys AlterTableDisableKeys AlterTableRemovePartitioning AlterTableWithValidation AlterTableWithoutValidation AlterTableSecondaryLoad AlterTableSecondaryUnload AlterTableRebuildPartition AlterTableReorganizePartition AlterTableCheckPartitions AlterTableExchangePartition...
ALTER TABLE modifies a table definition by altering, adding, or dropping columns and constraints. ALTER TABLE also reassigns and rebuilds partitions, or disables and enables constraints and triggers.
When you specify anENGINEclause,ALTER TABLErebuilds the table. This is true even if the table already has the specified storage engine. RunningALTER TABLEtbl_nameENGINE=INNODBon an existingInnoDBtable performs a“null”ALTER TABLEoperation, which can be used to defragment anInnoDBtable, as descri...
ALTER TABLE PARTITION modifies table partitioning, including adding, deleting, splitting, merging partitions, and modifying partition attributes.The name of the added par
华为云帮助中心为你分享云计算行业信息,包含产品介绍、用户指南、开发指南、最佳实践和常见问题等文档,方便快速查找定位问题与能力成长,并提供相关资料和解决方案。本页面关键词:rebuild 。