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()...
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
