Any ideas on how to optimise this ?

2001-03-26 Thread Peter Skipworth
Hi peeps, I've got a table which is basically a log of traffic on one of my websites - I have a seperate table per month, all of which are MERGED for queries which need access to more than a month's worth of data. select count(distinct cookie) as c,dayofmonth(event_time) as d from

Re: Any ideas on how to optimise this ?

2001-03-26 Thread Fred van Engen
Hi Peter, On Mon, Mar 26, 2001 at 12:20:14PM +0100, Peter Skipworth wrote: I've got a table which is basically a log of traffic on one of my websites - I have a seperate table per month, all of which are MERGED for queries which need access to more than a month's worth of data. select