本文主要描述如何查看索引的定义，以及查看该索引究竟是全局索引还是非全局索引。
适用版本
OceanBase 数据库 V2.x、V3.x 版本。
Oracle 模式下操作方法
obclient> select dbms_metadata.get_ddl('INDEX','GINDEX') from dual;
输出结果如下：
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| DBMS_METADATA.GET_DDL('INDEX','GINDEX')|
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| CREATE INDEX "ORA_POC"."GINDEX" on "ORA_POC"."T1" (
"B"
) GLOBAL
partition by range(b)
(partition P0 values less than (1),
partition P1 values less than (2),
partition P2 values less than (3));
|
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.228 sec)
MySQL 模式下操作方法
obclient [mysql]> show create table test;
输出结果如下：
+--------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+--------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| test01 | CREATE TABLE `test` (
`col1` int(11) DEFAULT NULL,
`col2` int(11) DEFAULT NULL,
KEY `idx_col1_test` (`col1`) BLOCK_SIZE 16384 GLOBAL
) DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMPRESSION = 'zstd_1.3.8' REPLICA_NUM = 1 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0
partition by range(col1) subpartition by list(col2)
(partition p0 values less than (100) (
subpartition sp0 values in (1,3),
subpartition sp1 values in (4,6),
subpartition sp2 values in (7,9)),
partition p1 values less than (200) (
subpartition sp3 values in (1,3),
subpartition sp4 values in (4,6),
subpartition sp5 values in (7,9))) |
+--------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.003 sec)
