Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
koushik_btech20
Creator
Creator

Oracle Extract is very slow

Extracting data from  oracle view in QlikSense (Qlik Ver - Nov 2018 patch 6 release)  which is taking too much time to load . I am using OLEDB as a data connection and for 18 million data taking 3-4 hours. 

In the oracle query I have group by and grouping set both keyword used, that might be one of the reason.

How to overcome this situation? Can anybody suggest any ideas?

Labels (2)
1 Reply
anushree1
Specialist II
Specialist II

Usually using Queries as is in Qlik takes time , so its suggested to convert it to Qlik Native  in the Script and then load.