It’s so easy to create, query and delete an index.
<!-- single column -->
CREATE INDEX index_name ON table_name (column_name);
<!-- multiple columns -->
CREATE INDEX index_name ON table_name (column1_name, column2_name);
<!-- uniq -->
CREATE UNIQUE INDEX index_name on table_name (column_name);
How to query an delete index
<!-- query index -->
select * from pg_indexes where tablename='tab1';
<!-- delete index -->
drop index tab1_bill_code_index ;
Click here to get more information.