teknokrat <[EMAIL PROTECTED]> writes:
Is it a good idea to index timestamp fields? what about date fields in general?
If you need to order by a timestamp, then it can be worthwhile.
If that timestamp can be null, and is rarely populated, then you might get a _big_ benefit from creating a partial index as with:
create index by_some_date on my_table(some_date) where some_date is not null;
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
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
