I am using PostgreSQL version 9.3 to create a database.
I have the following table test with some column lists.
create table test
(
cola varchar(10),
colb varchar(10),
colc varchar(10),
cold varchar(10)
);
Now I want to create indexes for some columns.
For instance:
I want to create a clustered index for colaand columns colb.
And I want to create a non-clustered index for colcand columns cold.
As I called this and this , I found out that there is no clustered and non-clustered index in PostgreSQL.
My question is . What type of index can I use instead of a clustered and non-clustered index in PostgreSQL that does the same job as clustered and non-clustered indexes?