在SQL Server中,确定索引大小的方法如下:
sys.indexes
系统视图查询索引信息,其中包括索引的大小。
SELECT
t.NAME AS TableName,
i.NAME AS IndexName,
i.index_id,
i.type_desc,
i.is_unique,
i.data_space_id,
f.NAME AS FilegroupName,
i.ignore_dup_key,
i.is_primary_key,
i.is_unique_constraint,
i.fill_factor,
i.is_padded,
i.is_disabled,
i.allow_row_locks,
i.allow_page_locks,
i.has_filter,
i.filter_definition,
i.is_hypothetical,
i.is_primary,
i.is_unique_index,
i.is_auto_created,
i.is_statistics,
i.is_clustered,
i.is_sparse,
i.has_drop_existing,
i.is_online_ddl,
i.is_disabled_dml_operation,
i.is_temporal,
i.is_external_reference,
i.is_hypothetical_index,
i.is_primary_key_index,
i.is_unique_constraint_index,
i.is_clustered_index,
i.is_nonclustered_index,
i.is_xml_index,
i.is_spatial_index,
i.is_statistics_index,
i.is_auto_created_index,
i.is_disabled_index,
i.is_hypothetical_index_name,
i.is_tracked_by_cdc,
i.is_sync_with_backup,
i.is_journalized,
i.is_preserve_row_order,
i.is_partitioned,
i.is_compressed,
i.is_row_store,
i.is_column_store,
i.is_optimized_for_memory,
i.is_data_compression_enabled,
i.is_encrypted,
i.is_page_compressed,
i.is_filtered,
i.is_disabled_for_replication,
i.is_hidden,
i.is_ignored_for_data_masking,
i.is_tracked_by_cdc_for_insert,
i.is_tracked_by_cdc_for_update,
i.is_tracked_by_cdc_for_delete,
i.is_tracked_by_cdc_for_operation,
i.is_tracked_by_cdc_for_truncate,
i.is_tracked_by_cdc_for_drop,
i.is_tracked_by_cdc_for_alter,
i.is_tracked_by_cdc_for_select,
i.is_tracked_by_cdc_for_update_old,
i.is_tracked_by_cdc_for_update_new,
i.is_tracked_by_cdc_for_operation_old,
i.is_tracked_by_cdc_for_operation_new,
i.is_tracked_by_cdc_for_truncate_old,
i.is_tracked_by_cdc_for_truncate_new,
i.is_tracked_by_cdc_for_drop_old,
i.is_tracked_by_cdc_for_drop_new,
i.is_tracked_by_cdc_for_alter_old,
i.is_tracked_by_cdc_for_alter_new,
i.is_tracked_by_cdc_for_select_old,
i.is_tracked_by_cdc_for_select_new,
i.is_tracked_by_cdc_for_insert_old,
i.is_tracked_by_cdc_for_insert_new,
i.is_tracked_by_cdc_for_delete_old,
i.is_tracked_by_cdc_for_delete_new,
i.is_tracked_by_cdc_for_update_mask,
i.is_tracked_by_cdc_for_operation_mask,
i.is_tracked_by_cdc_for_truncate_mask,
i.is_tracked_by_cdc_for_drop_mask,
i.is_tracked_by_cdc_for_alter_mask,
i.is_tracked_by_cdc_for_select_mask,
i.is_tracked_by_cdc_for_insert_mask,
i.is_tracked_by_cdc_for_delete_mask,
i.is_tracked_by_cdc_for_update_old_mask,
i.is_tracked_by_cdc_for_update_new_mask,
i.is_tracked_by_cdc_for_operation_old_mask,
i.is_tracked_by_cdc_for_operation_new_mask,
i.is_tracked_by_cdc_for_truncate_old_mask,
i.is_tracked_by_cdc_for_truncate_new_mask,
i.is_tracked_by_cdc_for_drop_old_mask,
i.is_tracked_by_cdc_for_drop_new_mask,
i.is_tracked_by_cdc_for_alter_old_mask,
i.is_tracked_by_cdc_for_alter_new_mask,
i.is_tracked_by_cdc_for_select_old_mask,
i.is_tracked_by_cdc_for_select_new_mask,
i.is_tracked_by_cdc_for_insert_old_mask,
i.is_tracked_by_cdc_for_insert_new_mask,
i.is_tracked_by_cdc_for_delete_old_mask,
i.is_tracked_by_cdc_for_delete_new_mask,
i.is_tracked_by_cdc_for_update_mask_old,
i.is_tracked_by_cdc_for_update_mask_new,
i.is_tracked_by_cdc_for_operation_mask_old,
i.is_tracked_by_cdc_
领取专属 10元无门槛券
手把手带您无忧上云