You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Customer reports that query select count(*) from table where col is null is consuming 100% CPU and not returning. Table has approximately 1M rows. Same query with count(primary_key_col) is fast, as expected.
The text was updated successfully, but these errors were encountered:
Customer reports that query
select count(*) from table where col is null
is consuming 100% CPU and not returning. Table has approximately 1M rows. Same query withcount(primary_key_col)
is fast, as expected.The text was updated successfully, but these errors were encountered: