List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 10 2001 4:51pm
Subject:Re: Index Question
View as plain text  
>Hello All,
>
>I've got a question that is likely an easy one, I just want confirmation from
>my peers.
>
>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.

>
>Thanks!
>
>Tyrone Mills
>=================================================================
>Internet service provided by telus.net  http://www.telus.net/


-- 
Paul DuBois, paul@stripped
Thread
Index Questiont_mills10 Sep
  • Re: Index QuestionRodney Broom10 Sep
  • Re: Index QuestionPaul DuBois10 Sep