The UNION statement will impose a removal of duplicate records. With such large record volumes this can impose a reasonable load on the processor.

If no duplicates are expected you...

Could you try the query (remotely) without having any function calls but with the 'where' condition in tact, for example:

SELECT '01',...