Index

• An index is used to enhance the data output with SELECT and WHERE

• If we are using the INSERT and UPDATE commands, it slows down data input.

• Without affecting any of the data, we can CREATE and DROP them.

• We can also create a unique index, which is similar to the UNIQUE constraint.

• Create Index - It is used to create a new index by defining the index name and table or column name on which the index is created.

• Drop Index -  The Drop index command is used to delete the current index.

• List indexes - It is used to represent how to list all indexes in the PostgreSQL database.

• Unique Index - The Unique index command allows us to specify the unique indexes step by step.

• Index on Expression - It is used to specify an index based on expressions.

• Partial index - The partial index is used to display the use of partial indexes.

• Re-index - To rebuild one or more indices, we can use the REINDEX command.

• Multicolumn Indexes - It is used to display multicolumn indexes usage to enhance the queries with several conditions in the WHERE clause.