Skip to content
Indexes · drill

The function that costs you the index

Return the ids of every event whose email is '[email protected]', regardless of how it was capitalised in the query — oldest id first. There is no index on lower(email), so find the way to ask that keeps the index you do have.

Your query

⌘⏎