duckdb has indexes to implement these
ɪ ᴋɴᴏᴡ ᴛʜɪꜱ ʙᴇᴄᴀᴜꜱᴇ ɪ ʜᴀᴠᴇ ɪᴍᴘʟᴇᴍᴇɴᴛᴇᴅ ᴍᴀɴʏ ᴅɪꜰꜰᴇʀᴇɴᴛ ᴋɪɴᴅꜱ ɪɴᴄʟᴜᴅɪɴɢ ᴛᴡᴏ ɢʀᴀᴘʜ ᴠᴇʀᴛᴇx ᴛᴀʙʟᴇꜱ.
Login to reply
Replies (1)
Not for I/LIKE as far I can understand from their docs. Seems they use art indexes but just for equality and IN conditions