List:General Discussion« Previous MessageNext Message »
From:Leandro GuimarĂ£es Faria Corcete DUTRA Date:November 12 2006 3:05am
Subject: Re: Optimize question
View as plain text  
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:leandro@stripped	     +55 (11) 2122 0302
xmpp:leandrod@stripped      ymsgr:sendIM?lgcdutra      BRASIL

Thread
Optimize questionFrancis8 Nov
  • Re: Optimize questionLeandro GuimarĂ£es Faria Corcete DUTRA12 Nov