User bio
404 bio not found
Member since Dec 1, 2015
Posts:
Replies:
show all 10
Tom Woodfin · May 14, 2016 go to post

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.

Tom Woodfin · May 14, 2016 go to post

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.

Tom Woodfin · Feb 16, 2016 go to post

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.

Certifications & Credly badges:
Tom has no Certifications & Credly badges yet.
Followers:
Tom has no followers yet.
Following:
Tom has not followed anybody yet.