List:General Discussion« Previous MessageNext Message »
From:Randy Paries Date:January 24 2007 6:18pm
Subject:best way to query this table
View as plain text  
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
Thread
best way to query this tableRandy Paries24 Jan
  • Re: best way to query this tableMartijn Tonies24 Jan
    • Re: best way to query this tableMiles Thompson25 Jan