Hello, I have a table that has a column that has a timestamp Column.
This table is going to get very large ( 1 or 2 million rows) and will be queried alot. Alot of these queries will be against timestamp column. These queries will be like, getting entries for today, this week and this month I have indexed the column, but i am wondering if i should create a couple of int columns that would be day of week, week of year and month and query against these instead. would love you opinions thanks Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]