Re: Using UNION instead of OR helps...
Ok is there a problem tou run 2 simple queries insted one complex?
I think 0.76 compared to 0.03 is still big
Also try your single line query with left join on union and or variants
-------------------------------Signature-----------------------------------------
http://www.nezavisim.com
I need job so if in your company there is need for optimizing and improving I am the man.
I can work from home via internet. Results are always best
I can complete all tasks from idea to final product, handling hardware desing, programming, installing and configuring all required hadrware and software.
And what can you?
Forum Moderators delete my posts so I cannot write delailed explanations, becaue this will be waste of time when my post is deleted by motherators
Edited 2 time(s). Last edit at 03/25/2010 08:11AM by Ventsislav Alexandriyski.