Indexes to Tables

* You can explicitly create indexes for table columns in PostgreSQL. Those indexes will speed up operations that look-up or sort according to values in those fields.

* The "CREATE INDEX" command is used for this purpose.

* Example:

Create an index according to the last name:

test=> CREATE INDEX employees_last_name_index
test->        ON employees
test->        ( last_name ) \g
CREATE


Create an index on both the first name and last name:

test=> CREATE INDEX employees_first_and_last_name_index
test->        ON employees
test->        ( last_name, first_name ) \g
CREATE


* To remove an index use the "DROP INDEX" command.

* Note: There is no "CREATE INDEX" command in the SQL 92 standard.