AntDB用户手册——建索引之复合索引

antdb=# create index idx_t_count_id_name on t_count (id,name);
CREATE INDEX
antdb=# \di+ idx_t_count_id_name
                                 List of relations
 Schema |        Name         | Type  | Owner  |  Table  |    Size    | Description 
--------+---------------------+-------+--------+---------+------------+-------------
 public | idx_t_count_id_name | index | danghb | t_count | 8192 bytes | 
(1 row)
复制