Would an index benefit select ... order by?

From: rihad <rihad(at)mail(dot)ru>
To: pgsql-general(at)postgresql(dot)org
Subject: Would an index benefit select ... order by?
Date: 2007-11-03 07:09:05
Message-ID: 472C1E91.3090906@mail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Should an index be used on a created_at timestamp column if you know you
will be using "ORDER BY created_at ASC|DESC" from time to time?

Thanks.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mikko Partio 2007-11-03 07:15:02 Re: Populating large DB from Perl script
Previous Message Jason Testart 2007-11-03 03:59:23 RPATH issue with libpq on Solaris 8 (gcc)