We are using a query to fetch the data from oracle database (around 90,000 records are there). The query contains 7 sub query. If we execute the query directly in TOAD it takes only 50 seconds. But when executing the same from QlikView it is taking 4 hours. Please could you advise the options to optimize this. Or is there any limitation in using sub queries in the QlikView.
We must avoid using sub-queries since they are not that performance oriented. As far as qlikview is concerned, as per my understanding, the QlikView lets the database engine take its time to run query and then use the result set.
Are you doing any aggregations on the result set as well? That might make it slow.
Also you can load individual tables in QlikView and then create a data model as required in using the sub-queries. Things can be made fast through scripting.
