Forum Discussion
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...
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