List:General Discussion« Previous MessageNext Message »
From:Eugene Kosov Date:June 21 2006 9:29pm
Subject:Re: query slow
View as plain text  
Jay Pipes wrote:
> SELECT  * FROM  `sav00_sava0400_dbf`
> emissao BETWEEN '2000-01-01' AND '2000-12-31'
> UNION ALL
> SELECT  * FROM  `sav00_sava0400_dbf`
> emissao BETWEEN '1999-12-01' AND '1999-12-31'
>
Why not:

SELECT  * FROM  `sav00_sava0400_dbf`
emissao BETWEEN '1999-12-01' AND '2000-12-31'

?? ;)
Thread
• Just need script for creating tablesXiaobo Chen21 Jun
  • Re: Just need script for creating tablesDaniel da Veiga21 Jun
  • RE: Just need script for creating tablesPeter Lauri21 Jun
    • query slowluiz Rafael21 Jun
      • Re: query slowJay Pipes21 Jun
        • Re: query slowEugene Kosov21 Jun
      • Re: query slowEugene Kosov21 Jun
    • Re: query slowluiz Rafael21 Jun
    • reclaim disk spaceluiz Rafael21 Jun
      • Re: reclaim disk spaceDan Buettner21 Jun
      • Re: reclaim disk spaceDan Nelson21 Jun
    • Re: query slowluiz Rafael25 Jun
  • Re: Just need script for creating tablesMartin Jespersen21 Jun
• RE: reclaim disk spaceGeorge Law21 Jun