>I've got a question that is likely an easy one, I just want confirmation from
>I have tables with a timestamp column and perform many selects and counts from
>these tables based on the date that the record was written.
>Can/should I index a timestamp column? I do my best to index columns that I
>specify in my WHERE clauses, however I haven't yet tried to index a timestamp
>column. Is it even possible? Is it advisable? Should I treat it as a char and
>limit it to just index on the portion of the data that distinguishes the date
>(I don't care about the time, just the date).
You can index it as a TIMESTAMP. If you don't care about the time,
maybe you should store separate DATE and TIME columns, though.
>Internet service provided by telus.net http://www.telus.net/
Paul DuBois, paul@stripped