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