kingbaseES基础 sys_index indisvalid 设置索引不可用

原创云散月明 All China Database Union 2022-07-12

428

Server：CentOS 7.2.1511
KingbaseES：V8R6C5B23

sys_index indisvalid 设置索引不可用

test=# select * from sys_stat_user_indexes where indexrelname='index_c1';
 relid | indexrelid | schemaname | relname | indexrelname | idx_scan | idx_tup_read | idx_tup_fetch 
-------+------------+------------+---------+--------------+----------+--------------+---------------
 16388 |      16397 | public     | t1      | index_c1     |        0 |            0 |             0
(1 行记录)

test=# \x                                               
扩展显示已打开.
test=# select * from sys_index where indexrelid=16397;
-[ RECORD 1 ]--+------
indexrelid     | 16397
indrelid       | 16388
indnatts       | 1
indnkeyatts    | 1
indisunique    | f
indisprimary   | f
indisexclusion | f
indimmediate   | t
indisclustered | f
indisvalid     | t
indcheckxmin   | f
indisready     | t
indislive      | t
indisreplident | f
indkey         | 1
indcollation   | 0
indclass       | 1978
indoption      | 0
indexprs       | 
indpred        | 

test=# update sys_index set indisvalid=false where indexrelid=16397;
UPDATE 1

test=# select * from sys_index where indexrelid=16397;              
-[ RECORD 1 ]--+------
indexrelid     | 16397
indrelid       | 16388
indnatts       | 1
indnkeyatts    | 1
indisunique    | f
indisprimary   | f
indisexclusion | f
indimmediate   | t
indisclustered | f
indisvalid     | f
indcheckxmin   | f
indisready     | t
indislive      | t
indisreplident | f
indkey         | 1
indcollation   | 0
indclass       | 1978
indoption      | 0
indexprs       | 
indpred        | 

test=# \dS+ t1
                         数据表 "public.t1"
 栏位 |  类型   | 校对规则 | 可空的 | 预设 | 存储  | 统计目标 | 描述 
------+---------+----------+--------+------+-------+----------+------
 c1   | integer |          |        |      | plain |          | 
索引：
    "index_c1" btree (c1) INVALID
访问方法 heap

test=# update sys_index set indisvalid=true where indexrelid=16397; 
UPDATE 1
test=# \dS+ t1                                                     
                         数据表 "public.t1"
 栏位 |  类型   | 校对规则 | 可空的 | 预设 | 存储  | 统计目标 | 描述 
------+---------+----------+--------+------+-------+----------+------
 c1   | integer |          |        |      | plain |          | 
索引：
    "index_c1" btree (c1)
访问方法 heap