adv_sample_user_queries_plus
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Last revisionBoth sides next revision | ||
adv_sample_user_queries_plus [2016/03/13 22:24] – daniel | adv_sample_user_queries_plus [2021/05/15 12:18] – index optimisation daniel | ||
---|---|---|---|
Line 25: | Line 25: | ||
<code sql> | <code sql> | ||
SELECT mail_id FROM mail m | SELECT mail_id FROM mail m | ||
- | WHERE status&(16+32)=0 | + | WHERE status&32=0 AND status&16 -- intentionally split to benefit from the index on mail.status& |
AND msg_date< | AND msg_date< | ||
AND thread_id is not null | AND thread_id is not null |
adv_sample_user_queries_plus.txt · Last modified: 2021/05/15 12:21 by daniel