It strongly depends from the queries. Usually yes
Il giorno 2010 5 15 16:20, "Armand Turpel" <aturpel@xxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
