https://community.qlik.com/t5/QlikView/Query-Execution-taking-long-time/m-p/1564608#M741853 <P>Reasons can be many; driver version, the network traffic, server load etc.<BR />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.</P><P>in any case 20 minute query is heavy, few options</P><P>-&nbsp;Why dont you split the queries and do the union/concatenate in qlik?</P><P>- if query cant be optimized further, Create a view for the same</P> Wed, 03 Apr 2019 13:32:31 GMT dplr-rn 2019-04-03T13:32:31Z https://community.qlik.com/t5/QlikView/Query-Execution-taking-long-time/m-p/1564560#M741852 <P>I have lengthy SQL Script which is written in Oracle SQL Query.</P><P>I created 4 different queries and join all the queries using "Union".</P><P>When i execute in Oracle, it is running fast and return result some short period of time (approx. 20 mins.)</P><P>but, the same query, when i reload in Qlikview, it i taking more than 60 minutes to return the result. Some times got hanged.</P><P>Why this much difference.</P> Sat, 16 Nov 2024 03:58:00 GMT https://community.qlik.com/t5/QlikView/Query-Execution-taking-long-time/m-p/1564560#M741852 saivina2920 2024-11-16T03:58:00Z https://community.qlik.com/t5/QlikView/Query-Execution-taking-long-time/m-p/1564608#M741853 <P>Reasons can be many; driver version, the network traffic, server load etc.<BR />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.</P><P>in any case 20 minute query is heavy, few options</P><P>-&nbsp;Why dont you split the queries and do the union/concatenate in qlik?</P><P>- if query cant be optimized further, Create a view for the same</P> Wed, 03 Apr 2019 13:32:31 GMT https://community.qlik.com/t5/QlikView/Query-Execution-taking-long-time/m-p/1564608#M741853 dplr-rn 2019-04-03T13:32:31Z