Query Execution taking long time

[saivina2920]

I have lengthy SQL Script which is written in Oracle SQL Query.

I created 4 different queries and join all the queries using "Union".

When i execute in Oracle, it is running fast and return result some short period of time (approx. 20 mins.)

but, the same query, when i reload in Qlikview, it i taking more than 60 minutes to return the result. Some times got hanged.

Why this much difference.

[dplr-rn · Accepted solution]

Reasons can be many; driver version, the network traffic, server load etc.
If i recall correctly oracle display doesn't return all the values when you run it on Oracle SQl developer. How are you running the query which takes 20 mins.

in any case 20 minute query is heavy, few options

- Why dont you split the queries and do the union/concatenate in qlik?

- if query cant be optimized further, Create a view for the same