Would it not be possible for the optimiser to recognise these two queries as
the same and use the same plan?

select * from customers
where link in
('NOR0000001')

select * from customers
where link in
(select link from customers
where link = 'NOR0000001')

I can understand if the IN clause has a reference to the master table