SHOW CREATE INDEX¶
SHOW CREATE INDEX
展示创建 Tag 或者 Edge type 时使用的 nGQL 语句,其中包含索引的详细信息,例如其关联的属性。
语法¶
SHOW CREATE {TAG | EDGE} INDEX <index_name>;
示例¶
用户可以先运行SHOW TAG INDEXES
查看有哪些 Tag 索引,然后用SHOW CREATE TAG INDEX
查看指定索引的创建信息。
nebula> SHOW TAG INDEXES;
+------------------+----------+----------+
| Index Name | By Tag | Columns |
+------------------+----------+----------+
| "player_index_0" | "player" | [] |
| "player_index_1" | "player" | ["name"] |
+------------------+----------+----------+
nebula> SHOW CREATE TAG INDEX player_index_1;
+------------------+--------------------------------------------------+
| Tag Index Name | Create Tag Index |
+------------------+--------------------------------------------------+
| "player_index_1" | "CREATE TAG INDEX `player_index_1` ON `player` ( |
| | `name`(20) |
| | )" |
+------------------+--------------------------------------------------+
Edge type 索引可以用类似的方法查询:
nebula> SHOW EDGE INDEXES;
+----------------+----------+---------+
| Index Name | By Edge | Columns |
+----------------+----------+---------+
| "follow_index" | "follow" | [] |
+----------------+----------+---------+
nebula> SHOW CREATE EDGE INDEX follow_index;
+-----------------+-------------------------------------------------+
| Edge Index Name | Create Edge Index |
+-----------------+-------------------------------------------------+
| "follow_index" | "CREATE EDGE INDEX `follow_index` ON `follow` ( |
| | )" |
+-----------------+-------------------------------------------------+
最后更新:
September 4, 2023