On Wed, Oct 15, 2003 at 21:25:17 +0100,
  teknokrat <[EMAIL PROTECTED]> wrote:
> 
> I have a lot of queries of the " where timestamp < some date " type and 
> was wondering if an index would improve performance. None of the 
> timestamps are null and they are always populated

Unless that query returns only a small fraction of the table (which would
be unusual for a before some date restriction) or you order by the date,
an index probably won't help.

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to