Thread: index or not

Hi,
Does it make sense to create indexes on a table which only contains
bigint fields? Is there any performance gain?

Example:

Table x_rel
id_a bigint
id_b bigint
id_c bigint
id_d bigint

Thanks for replying,
Armand

#####################################################################################
Scanned by MailMarshal - Marshal's comprehensive email content security solution.
#####################################################################################

It strongly depends from the queries. Usually yes

Il giorno 2010 5 15 16:20, "Armand Turpel" <aturpel@mnhn.lu> ha scritto:

Hi,
Does it make sense to create indexes on a table which only contains bigint fields? Is there any performance gain?

Example:

Table x_rel
id_a bigint
id_b bigint
id_c bigint
id_d bigint

Thanks for replying,
Armand

#####################################################################################
Scanned by MailMarshal - Marshal's comprehensive email content security solution. #####################################################################################

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general