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
1 comment
[ 2.5 ms ] story [ 14.9 ms ] threadIf 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