index or not

From: "Jean-Yves F(dot) Barbier" <12ukwn(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: index or not
Date: 2011-12-12 18:10:53
Message-ID: 20111212191053.37b15bc7@anubis.defcon1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi list,

I wonder if indexes are relevant or not on a small table?
(250 rows, 10 columns, often retrieved in different order)

JY
--
If you have never been hated by your child, you have never been a
parent. -- Bette Davis

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Andreas Kretschmer 2011-12-12 18:15:32 Re: index or not
Previous Message Thomas Kellerer 2011-12-12 08:25:06 Re: SELECT from two tables with different field names?