openGauss每日一练第9天 | 学习心得体会及课后作业

1. 创建表products, 分别为表创建一个unique索引1，指定b-tree索引2和表达式索引3

create schema s1;
create table s1.products (
id integer not null,
name char(40),
price float4,
category char(30),
pnum integer,
description char(50
create unique index products_index1 on s1.products(id);
create index products_index2 on s1.products using btree(id);
create index products_index3 on s1.products(substr(name, 1, 4));
\

2. 设置索引1不可用，修改索引2的表空间，重命名索引3

alter index s1.products_index1 unusable;
create  tablespace test relative location 'tablespace1/test';
alter index s1.products_index2 set tablespace test;
alter index s1.products_index3 rename to products_index4;
\

3. 重建索引2和products的所有索引

alter index s1.products_index2 rebuild;
reindex index products_index5;
reindex table s1.products;
\

4. 使用\d+和系统视图pg_indexes查看索引信息

\d+
select * from pg_indexes where tablename = 'products';
\

5. 删除索引、表和表空间

drop index s1.products_index1;
drop index s1.products_index2;
drop index s1.products_index4;
drop index s1.products_index5;
drop table s1.products;
drop schema s1;