We have a query that needs to compare a value to a list of values in a where clause. The strings are known and discrete. Does IN use the
= operator to compare values? Would a b-tree index work for this use case? Example query:
create table fruit ( name character varying NOT null ) select * from fruit where name in ('Banana', 'Apple');
Let's assume at the moment we do not want to normalize the data (even though I agree that makes the most sense).