List:General Discussion« Previous MessageNext Message »
From:t_mills Date:September 10 2001 5:32pm
Subject: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).


Tyrone Mills
Internet service provided by
Index Questiont_mills10 Sep
  • Re: Index QuestionRodney Broom10 Sep
  • Re: Index QuestionPaul DuBois10 Sep