Re: Performance doubt on my explicit cursor with a subquery

C Chang wrote:

> I figured out the following way to my IN list in the explicit
> cursor:
>
> Cursor c_qty ( p_siteID IN varchar2, p_vendorID IN varchar2) is
> SELECT SUM(r.qty), r.qty_unit
> FROM receipts r, lines p, heads h
> WHERE r.site_id= p_siteID
> AND h.vendor_id IN (select vendor_id
> from vendor v,
> (select db_num
> from vendor
> where vendor_id = p_vendorID ) d
> where v.db_num = d.db_num)
> AND 'other conditions'
> GROUP BY r.qty_unit, r.site_id;
>
> But the problem is will it be too resource extensive if this cursor been
> called in another dynamic cursor loop for 8K times?
>
> C Chang

I don't get the point of your nested subselects in the WHERE clause. You are selecting from vendor and the joining it to another select from the same table. Not knowing your schema I am wondering why you aren't doing it in one step.

Daniel Morgan Received on Thu Feb 13 2003 - 22:21:09 CST