from Hacker News

Tuning MySQL and the Ghost of Index Merge Intersection

by agnivade on 12/15/20, 1:46 PM with 1 comments

• by ammyinsane on 12/15/20, 2:37 PM

  Don't have this in your query/app: "AND DeleteAt = 0"

  If your app must depend on that,put the delete posts in a deletepostsID table and do a join.

  IIRC its because mysql queries can only use one index at a time (per table) and any type of binary/enums/ 0 /null tables will always force a full table scan regardless of indexes