ahhhh let me bump the issue on their end again, sorry for the false alarm
ahhhh let me bump the issue on their end again, sorry for the false alarm
id is first in your index?id and the expression (tiktok_link IS NULL OR tiktok_link = '')id < will not use other columns in the index after thatINDEXED BY, it does not work neitherid < will make sqlite scan the table?(tiktok_link IS NULL OR tiktok_link = '') in index does not work like mysqltiktok_link covers that anywayindexed by reduces my rows read?indexed byINDEXED BY after all, sqlite is smart enough to choose the right index for me.ABC%wrangler@3.29.0(tiktok_link IS NULL OR tiktok_link = '')(tiktok_link IS NULL OR tiktok_link = '')id <id <INDEXED BYINDEXED BYtiktok_linkindexed byindexed byABC%wrangler@3.29.0SELECT ... FROM project WHERE id < '01HQ81GRDX539N2EJSW1ECGRMY' AND (tiktok_link IS NULL OR tiktok_link = '')SELECT ... FROM project WHERE (tiktok_link IS NULL OR tiktok_link = '') and id < '01HQ81GRDX539N2EJSW1ECGRMY'CREATE INDEX project_tiktok_link_id_idx ON project (tiktok_link, id);SELECT ... FROM project INDEXED BY project_tiktok_link_id_idx WHERE tiktok_link IS NULL and id < '01HQ81GRDX539N2EJSW1ECGRMY'