> 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()...