Skip to main content

Qlik

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
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
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: 
Anonymous
Not applicable
‎2013-12-15 05:14 AM

GROUP BY PERFORMANCE

HI

I HAVE A VERY BIG TABLE 500 FIELDS 40M ROWS TRYING TO GROUP THIS TABLE AND IT TAKES FOREVER AROUND 8HRS

ANY IDEAS HOW TO IMPROVE THIS GROUP BY???

TRIED TO CUT THIS TABLE TO 5 SEPARATE TABLES  THAT HAVE 100 FIELDS AND 40M ROWS AND THEN JOIN BACK ALL 5 TABLES BACK TO ONE THIS DIDN'T IMPROVE THE PERFORMANCE BY MUCH

ANY OTHER IDEAS?

THANKS

JT

452 Views
0 Likes
1 Reply
vikasmahajan
MVP
MVP
‎2013-12-15 06:26 AM

can you post script and purpose of joining tables ?

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
168 Views
0 Likes