List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:July 11 1999 4:09pm
Subject:Re: query optimization..
View as plain text  
At 4:44 PM +0300 7/11/1999, Tõnu Samuel wrote:
>Alex Krohn wrote:
>> SELECT d.*
>> >FROM Data as d LEFT JOIN Alt as a ON d.ID = a.DataID
>> WHERE d.Category = 5 OR a.Category = 5
>
>> Any ideas would be really appreciated!
>
>This OR clause is prorably is bad. I think you get much quicker result
>if you do two different queries:
>
>
>First:
>
>WHERE d.Category = 5
>
>and other
>
>WHERE a.Category = 5


Would you explain why this would make a difference?  Just curious.

--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/
Thread
query optimization..Alex Krohn11 Jul
  • Re: query optimization..Tõnu Samuel11 Jul
    • Re: query optimization..Paul DuBois11 Jul
  • Re: query optimization..Tõnu Samuel14 Jul
Re: query optimization..Alex Krohn11 Jul
  • Re: query optimization..Christian Mack17 Jul