topic Re: Oracle query performance in QlikView https://community.qlik.com/t5/QlikView/Oracle-query-performance/m-p/405867#M699490 <HTML><HEAD></HEAD><BODY><P>There are two issues here:<BR />1. QV11 script doesn't return an error if the SQL is incorrect, just loads 0 rows and continues.&nbsp; Probbaly this is your situation.<BR />2. Using date condition in Oracle within QV script - see this <A _jive_internal="true" href="https://community.qlik.com/docs/DOC-1321">http://community.qlik.com/docs/DOC-1321</A></P><P></P><P>Regards,<BR />Michael</P></BODY></HTML> Tue, 04 Dec 2012 16:30:10 GMT Anonymous 2012-12-04T16:30:10Z Oracle query performance https://community.qlik.com/t5/QlikView/Oracle-query-performance/m-p/405866#M699488 <HTML><HEAD></HEAD><BODY><P>I have an Oracle query that gives me a good and quick result in an Oracle query tool.</P><P></P><P>It gives me 0 records in return when running in Qlikview when the Oracle query has a where clause: Where datum = '3-12-2012' </P><P>It runs indefinite when the where clause is Where datum &gt; '3-12-2012' </P><P></P><P>any ideas ?</P></BODY></HTML> Tue, 04 Dec 2012 16:08:42 GMT https://community.qlik.com/t5/QlikView/Oracle-query-performance/m-p/405866#M699488 2012-12-04T16:08:42Z Re: Oracle query performance https://community.qlik.com/t5/QlikView/Oracle-query-performance/m-p/405867#M699490 <HTML><HEAD></HEAD><BODY><P>There are two issues here:<BR />1. QV11 script doesn't return an error if the SQL is incorrect, just loads 0 rows and continues.&nbsp; Probbaly this is your situation.<BR />2. Using date condition in Oracle within QV script - see this <A _jive_internal="true" href="https://community.qlik.com/docs/DOC-1321">http://community.qlik.com/docs/DOC-1321</A></P><P></P><P>Regards,<BR />Michael</P></BODY></HTML> Tue, 04 Dec 2012 16:30:10 GMT https://community.qlik.com/t5/QlikView/Oracle-query-performance/m-p/405867#M699490 Anonymous 2012-12-04T16:30:10Z