Forum Discussion

akash0800's avatar
akash0800
Icon for Helper I rankHelper I
3 years ago

Improve Query performance for large tables

Hi All,   I need your help in how to improve the performance of a query that is handling huge data.   Here, I am having a data that is more that 7 million rows. Within this data there is a column...
Need Help
ppm1's avatar
ppm1
Icon for Solution Sage rankSolution Sage
3 years ago

Pivoting the data is usually not a good idea (especially when it results in 400 more columns!). I would keep it unpivoted and post here on the community for help on the analysis of the unpivoted data.

 

Pat