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).

Thanks!

Tyrone Mills
=================================================================
Internet service provided by telus.net  http://www.telus.net/
Thread
Index Questiont_mills10 Sep
  • Re: Index QuestionRodney Broom10 Sep
  • Re: Index QuestionPaul DuBois10 Sep