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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
koushik_btech20
Creator
Creator
‎2020-01-20 04:16 AM

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)
Labels
1,277 Views
0 Likes
1 Reply
anushree1
Specialist II
Specialist II
‎2020-01-20 06:43 AM

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

 

 

1,249 Views
0 Likes