Hey @Max (@rozenmd) any dates planned to release D1 on South America?
Hey @Max (@rozenmd) any dates planned to release D1 on South America?
EXPLAIN QUERY PLAN
rows read.raw()?.raw() To include an array of column names in the results when using raw(), use raw({columnNames: true}).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 thatEXPLAIN QUERY PLANrows read.raw().raw()raw({columnNames: true})idid(tiktok_link IS NULL OR tiktok_link = '')id <CREATE INDEX project_tiktok_link_is_empty_idx ON project (tiktok_link IS NULL OR tiktok_link == '');SELECT * FROM project WHERE id = '01HQ81GRDX539N2EJSW1ECGRMY' AND (tiktok_link IS NULL OR tiktok_link = '')CREATE INDEX project_tiktok_link_is_empty_and_id_idx ON project (tiktok_link IS NULL OR tiktok_link == '', id);CREATE INDEX project_tiktok_link_is_empty_and_id_idx ON project (tiktok_link, 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'