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.