SHOW CREATE INDEX

SHOW CREATE INDEX展示创建Tag或者Edge type时使用的nGQL语句，其中包含索引的详细信息，例如其关联的属性。

语法

  1. SHOW CREATE {TAG | EDGE} INDEX <index_name>;

示例

用户可以先运行SHOW TAG INDEXES查看有哪些Tag索引，然后用SHOW CREATE TAG INDEX查看指定索引的创建信息。

  1. nebula> SHOW TAG INDEXES;
  2. +------------------+----------+----------+
  3. | Index Name       | By Tag   | Columns  |
  4. +------------------+----------+----------+
  5. | "player_index_0" | "player" | []       |
  6. | "player_index_1" | "player" | ["name"] |
  7. +------------------+----------+----------+
  9. nebula> SHOW CREATE TAG INDEX player_index_1;
  10. +------------------+--------------------------------------------------+
  11. | Tag Index Name   | Create Tag Index                                 |
  12. +------------------+--------------------------------------------------+
  13. | "player_index_1" | "CREATE TAG INDEX `player_index_1` ON `player` ( |
  14. |                  |  `name`(20)                                      |
  15. |                  | )"                                               |
  16. +------------------+--------------------------------------------------+

Edge type索引可以用类似的方法查询：

  1. nebula> SHOW EDGE INDEXES;
  2. +----------------+----------+---------+
  3. | Index Name     | By Edge  | Columns |
  4. +----------------+----------+---------+
  5. | "follow_index" | "follow" | []      |
  6. +----------------+----------+---------+
  8. nebula> SHOW CREATE EDGE INDEX follow_index;
  9. +-----------------+-------------------------------------------------+
  10. | Edge Index Name | Create Edge Index                               |
  11. +-----------------+-------------------------------------------------+
  12. | "follow_index"  | "CREATE EDGE INDEX `follow_index` ON `follow` ( |
  13. |                 | )"                                              |
  14. +-----------------+-------------------------------------------------+

历史版本兼容性

Nebula Graph 2.0.1中， SHOW TAG/EDGE INDEXES 语句仅返回 Names。

最后更新: November 1, 2021