AntDB用户手册——建索引之部分索引

AntDB中支持对某个字段的部分值创建索引，使用索引的场景会更加灵活。

antdb=# create index idx_t_count_id_part on t_count (id) where id < 10;
CREATE INDEX
antdb=# \di+ idx_t_count_id_part
                                 List of relations
 Schema |        Name         | Type  | Owner  |  Table  |    Size    | Description 
--------+---------------------+-------+--------+---------+------------+-------------
 public | idx_t_count_id_part | index | danghb | t_count | 8192 bytes | 
(1 row)
antdb=# \d+ t_count
                                  Table "public.t_count"
 Column |  Type   | Collation | Nullable | Default | Storage  | Stats target | Description 
--------+---------+-----------+----------+---------+----------+--------------+-------------
 id     | integer |           |          |         | plain    |              | 
 name   | text    |           |          |         | extended |              | 
Indexes:
    "idx_t_count_id_part" btree (id) WHERE id < 10
Distribute By: HASH(id)
Location Nodes: ALL DATANODES