---
title: 如何查看索引的定义，以及查看该索引究竟是全局索引还是非全局索引-OceanBase数据库使用指南
description: 了解OceanBase数据库在实际应用中关于如何查看索引的定义，以及查看该索引究竟是全局索引还是非全局索引相关的常见问题和使用技巧，帮助您快速解决如何查看索引的定义，以及查看该索引究竟是全局索引还是非全局索引的难题。
---
切换语言

- 简体中文
- English

划线反馈

# 如何查看索引的定义，以及查看该索引究竟是全局索引还是非全局索引

更新时间：2026-05-22 08:56

适用版本： V2.2.x、V3.1.x、V3.2.x 内容类型：How-to  

本文主要描述如何查看索引的定义，以及查看该索引究竟是全局索引还是非全局索引。

## 适用版本

OceanBase 数据库 V2.x、V3.x 版本。

## Oracle 模式下操作方法

```shell
obclient> select dbms_metadata.get_ddl('INDEX','GINDEX') from dual;

```

输出结果如下：

```shell
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 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 模式下操作方法

```shell
obclient [mysql]> show create table test;

```

输出结果如下：

```shell
+--------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 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)

```

Previous

[如何直接查索引表的内容](https://www.oceanbase.com/knowledge-base/oceanbase-database-1000000000545334)

Next

[如何查看当前查询是否使用了索引](https://www.oceanbase.com/knowledge-base/oceanbase-database-20000000113) ![有帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*y6ocSqN8cqsAAAAAAAAAAAAAARQnAQ)![无帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*BG9IQJyLHF8AAAAAAAAAAAAAARQnAQ)![反馈](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*eTWdQKCRKHwAAAAAAAAAAAAAARQnAQ)[AI](https://www.oceanbase.com/obi) 咨询热线