PolarDB:グローバルインデックスを表示

構文

SHOW GLOBAL {INDEX | INDEXES} [FROM [schema_name.]tbl_name]

schema_nameとtbl_nameはオプションで、テーブル名のフィルタリングや他のデータベースのテーブルに関する情報の表示に使用されます。

SHOW GLOBAL INDEX; # 現在のデータベース内のすべてのテーブルのグローバルセカンダリインデックスを照会します。
SHOW GLOBAL INDEX FROM xxx_tb; # 現在のデータベースのxxx_tbテーブルのグローバルセカンダリインデックスを照会します。
SHOW GLOBAL INDEX FROM xxx_db.xxx_tb; # xxx_dbデータベースのxxx_tbテーブルのグローバルセカンダリインデックスを照会します。 このステートメントは、クロスデータベースクエリを実行するために実行されます。

例

ショーグローバルインデックス;
+ --------------------- ---------------------- + --------- + ------------------------------- ---------------------------- + ---------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ + ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ + ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- +
| スキーマ | テーブル | NON_UNIQUE | KEY_NAME | INDEX_NAMES | COVERING_NAMES | INDEX_TYPE | DB_PARTITION_POLICY | DB_PARTITION_POLICY | DB_PARTITION_COUNT | TB_PARTITION_KEY | TB_PARTITION_COUNTIUS
+ --------------------- ---------------------- + --------- + ------------------------------- ---------------------------- + ---------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ + ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ + ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- +
| XXXX_DRDS_LOCAL_APP | full_gsi_ddl_renamed | flo| c_doub_long | id, c_bit_1, c_bitc_pr _double, c_bit_32, c_ginget_bit_32, c_tinyint_1, c_tinyint_1_un, c_tinyint_4, c_tinint_4_medit_c_medi_c__1 8_medi_c_ma_ma_1_alun c_datetime_6、c_timestamp_1、c_timestamp_3、c_ASHマルチタイム、c_time_1 | c_time_IC | | c_time_long | | c_time_6、c_year、c_year_4、c_char、c_binary、c_varbinary、c_bloc_c_text_c_tel_c_c_ting_c_c_c_string、text、c__ c_cremid、c__ 、c__ crening、c__ crening_crening、| XXXX_DRDS_LOCAL_APP | float | 1 | g_i_c_ddl_c_mediumint_1 | c_mediumint_1 | id, c_bit_1, c_bitp_cpr_double, c_bit_32, c_ginbit_32, c_tinyint_1, c_tinyint_1_un, c_tinyint_4, c_tinint_c__ medi_c_c___ma_ma_c_1_8_tin_ma_ma__ma_ma_ma_g_ma_ma_g_ma_ma_g_16,_,_,_, c_timestamp_1、c_timestamp_3、c_time、c_ASH、c_minc_time_1、c_time_3、c_timeall_6 | NULL | c_year_4、c_char、c_binary、c_varbinary、c_blob_tiny、c_bloc_c_medy_string、c_bloc_medi_c_c_string、c_long
| XXXX_DRDS_LOCAL_APP | full_gsi_ddl_renamed, | g_i_c_ddl_c_smallint_16_un | c_smallint_c64_un, bimt_cpr_c_time_1, c_ginbit_8, c_bit_16, c_bit_32, c_tinyint_1, c_tinyint_ma_c_1__medit_c_1_medi_c____c_1_int__, 8un,_,_, c__, c__, c____medi_medi_medi___ c_datetime_6、c_intimestamp_1、c_timestamp_3、c_timesm_ASH 16time、c_multiegon_c_line_3、c_time_6 | | c_year、c_yararchar、c_binary、c_varbinary、c_blob_text_c_string、j_text_cs_string、c_cum、geomet_c_c_c_c_text_c_c_c_c_c_text_c_cum可能性、c_c
| XXXX_DRDS_LOCAL_APP | t_order | 0 | g_i_seller | seller_id | id、order_id | HASH | seller_id | HASH | 4 | seller_id | HASH | 2 | 作成 |
+ --------------------- ---------------------- + --------- + ------------------------------- ---------------------------- + ---------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ + ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ + ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- +
セットの4列 (0.01秒)