go to post Tom Woodfin · May 14, 2016 You have the right idea to 'literalize' the 0 so it isn't treated as a parameter, but the syntax isn't quite right. Try: AND consolidateID = ((0)) Then the optimizer should know that this condition will be non-selective. 1 0 https://community.intersystems.com/post/how-do-i-force-outliers-be-ignored-20161#comment-84561 go to post Tom Woodfin · May 14, 2016 Great!Note that the infrastructure for %PARALLEL is substantially improved in the upcoming 2016.2 release. If your query can be parallelized, you ought to see even better performance there. 0 0 https://community.intersystems.com/post/how-do-i-force-outliers-be-ignored-20161#comment-9141 go to post Tom Woodfin · Feb 16, 2016 You want to use the concatenate operator: || e.g.: SELECT EventType || ';' || InitiatedAt as k, COUNT(*) as cnt FROM HS_IHE_ATNA_Repository.Aggregation WHERE EventType = 'LOGIN' AND LocalDateTime > '2016-02-16 11:00:00' GROUP BY EventType, InitiatedAt + is the addition operator, which implicitly treats string values as 0. 4 0 https://community.intersystems.com/post/concatenate-columns-results-group#comment-3781 Certifications & Credly badges:Tom has no Certifications & Credly badges yet.Global Masters badges:Tom has no Global Masters badges yet.Followers:Tom has no followers yet.Following:Tom has not followed anybody yet.