Only if you want to see duplicate rows :-)
On Tue, Aug 17, 2010 at 2:21 PM, Ananda Kumar wrote:
> use UNION ALL ..instead of UNION for better performance...
>
> On Tue, Aug 17, 2010 at 5:01 PM, Johan De Meersman >wrote:
>
> > You may want to split of your or conditions into a separate query, an
use UNION ALL ..instead of UNION for better performance...
On Tue, Aug 17, 2010 at 5:01 PM, Johan De Meersman wrote:
> You may want to split of your or conditions into a separate query, and use
> UNION.
>
> On Tue, Aug 17, 2010 at 11:22 AM, Влад Р wrote:
>
> > The main problem - if add in Join o
You may want to split of your or conditions into a separate query, and use
UNION.
On Tue, Aug 17, 2010 at 11:22 AM, Влад Р wrote:
> The main problem - if add in Join on `OR`-condition, select become
> VERY slow. I realy
> have to use this condition.
>
> -- ---
