#what is faster, or no difference?
4 messages · Page 1 of 1 (latest)
when in doubt, use the SQL command EXPLAIN
but = usually performs better then LIKE (contains) or ILIKE(iexact or icontains)
iexact will convert to UPPER in postgres
WHERE "table"."foo" = 'value' -- foo=value
WHERE UPPER("table"."foo"::text) = UPPER('value') -- foo__iexact=value