>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, [EMAIL PROTECTED]
---------------------------------------------------------------------
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
