Thanks, now the SELECT from the huge VIEW runs under one third of the original runtime.
Nice.
select * from v1 where code||num = 'AAA2005000001';
I do not know if it is at all possible, but maybe you could use a rule to, on select to your view, do instead a select on the two separate columns used in the key, with a bit of massaging on the values using substring()...
