I had tried to use the UNION ALL but the response time seems inconsistent.
What do you mean by that? Do you realy need UNION or would UNION ALL also be ok?