On Wed, 08 Nov 2006 15:38:27 -0500, Francis wrote: > If I do a select to get the log for this date 2006-01-01 : > Select * from mytable where mydate => '2006-01-01' and mydate <= > '2006-01-01'. > > Do you think is more faster to do on table with have only one date or is > the same think if I do it on table whit all day ?
That is what indexes are for. > And last question, if I do a group by, I think the group by is > faster on column as type INT Vs Varchar ? Not necessarily so. -- Leandro Guimarães Faria Corcete DUTRA +55 (11) 5685 2219 http://br.geocities.com./lgcdutra/ +55 (11) 9406 7191 mailto:[EMAIL PROTECTED] +55 (11) 2122 0302 xmpp:[EMAIL PROTECTED] ymsgr:sendIM?lgcdutra BRASIL -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]