"Eric" <[EMAIL PROTECTED]> writes:
> select
> o.orderid,
> ol.itemcode,
> ol.itemname,
> ol.uom,
> qty_available( ol.itemcode, ol.uom ) as "Qty On Hand"
> from
> orders o,
> orderlines ol,
> where
> o.status = 'OPEN' and
> ol.orderid = o.orderid and
> qty_onhand( ol.itemcode, ol.uo
I have a SQL which uses a function for one of the returned rows. This
stored function does calculations that are expensive & slow. I am looking
for ways to speed up this query but having no luck.
Any SQL geniuses out there help me with this?
select
o.orderid,
ol.itemcode,
ol.itemname,
ol.
