Oracle query performance

[#1]

I have an Oracle query that gives me a good and quick result in an Oracle query tool.

It gives me 0 records in return when running in Qlikview when the Oracle query has a where clause: Where datum = '3-12-2012'

It runs indefinite when the where clause is Where datum > '3-12-2012'

any ideas ?

[Anonymous · Accepted solution]

There are two issues here:
1. QV11 script doesn't return an error if the SQL is incorrect, just loads 0 rows and continues.  Probbaly this is your situation.
2. Using date condition in Oracle within QV script - see this http://community.qlik.com/docs/DOC-1321

Regards,
Michael