Re: best way to query this table

2007-01-24 Thread Miles Thompson
At 03:31 PM 1/24/2007, Martijn Tonies wrote: Hello Randy, > 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 wi

Re: best way to query this table

2007-01-24 Thread Martijn Tonies
Hello Randy, > 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

best way to query this table

2007-01-24 Thread Randy Paries
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