Louis :emacs: on Nostr: SQL pro tip of the day: sub-optimal: SELECT count(*) FROM mytable WHERE mycolum IS ...

SQL pro tip of the day:

sub-optimal:

SELECT count(*)
FROM mytable
WHERE mycolum IS NOT NULL;


optimal:

SELECT count(mycolumn)
FROM mytable;


#sql #postgresql #mysql #sqlite