Improve performance by moving to count(1) instead of count(*)

calogica / dbt-expectations

Port(ish) of Great Expectations to dbt test macros

https://calogica.github.io/dbt-expectations/

Apache License 2.0

989 stars 120 forks source link

Improve performance by moving to count(1) instead of count(*) #304

Open milonimrod opened 3 months ago

milonimrod commented 3 months ago

Is your feature request related to a problem? Please describe. We found that on large tables some tests work slow. We saw that the count function is using count(*) instead of a much faster count(1)

Describe the solution you'd like Opened a PR for a solution