I have a query with an in subquery like
where x in (select x from y);
Now the subquery is not related to the outer query so it always returns
the same set. Is this subselect executed each time or just once? If it
is executed each time, if I create a function would that then be only
executed once?
--
Dave Smith
CANdata Systems Ltd
416-493-9020