I am writing a Select query to load one Fact table. This requires 75 columns in SELECT along with SUM() which leads to use all columns in GROUP by as well. This is messing up my query, group by with 75 columns not performing fine. Can any one suggest on tuning this query
@mbvnaveen5 There are ways to avoid the problem with too many columns in the group by clause. In fact, it might be possible to get rid of such clause altogether by restating the query with using APPLY. While you don't have to post the entire query, post a short version of it (with just few columns included), or else provide some details, including the version of SQL Server in question. Otherwise, it is difficult to offer a meaningful help. Thank you.
18 People are following this question.
