CREATE INDEX project_tiktok_link_is_empty_and_id_idx ON project (tiktok_link, id);
TTTrows readT
M
FMFFMFM
.raw()?FMF.raw()M To include an array of column names in the results when using raw(), use raw({columnNames: true}).FF
MMFFMMFFFMM
idid(tiktok_link IS NULL OR tiktok_link = '')id < will not use other columns in the index after thatTINDEXED BYid < will make sqlite scan the table?T
STMTT
hope you don't mindMMT(tiktok_link IS NULL OR tiktok_link = '')tiktok_linkrows read.raw().raw()raw({columnNames: true})id <id <SELECT ... 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'
CDCloudflare Developers / pages-helpCDCloudflare Developers / workers-and-pages-helpCDCloudflare Developers / general-helpCDCloudflare Developers / workers-and-pages-help