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/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php