String index for a list of values using IN($1,$2): will a btree index work?
An IN statement can be considered a chained OR, e.g. WHERE name IN ('Banana','Apple') is equivalent to WHERE (name = 'Banana' OR name = 'Apple').
The data is normalized once you define Name as your primary key as that would uniquely identify a fruit for the purposes of this example.  So if that was your primary key, there would be a B-tree present and the engine would (generally) do two seeks for your query: one for 'Banana' and one for 'Apple'.
If there was a secondary index on Name, the engine would (again, generally) do two seeks on that index and two seeks against the table.