Explain Plan For Query

From: Salaam Yitbarek <yitbsal_at_yahoo.com>
Date: 11 Apr 2002 08:15:09 -0700
Message-ID: <77439c33.0204110715.12487d1d@posting.google.com>

Hi,

We're running 8.1.7 on a Solaris 5.7 box.

I have the following simple cursor in a stored procedure. It fetches, at most, 2 records. I only want the first.

CURSOR cur_Terminated IS
SELECT TERMINATED
FROM VECTOR
WHERE VECTOR_ID = VectorId_in
ORDER BY VERSION DESC;
...

OPEN cur_Terminated;
FETCH cur_Terminated INTO var_Terminated; CLOSE cur_Terminated;
...

It takes over 4 minutes to run.

The same query, run from the sql prompt, takes milliseconds, and has a good explain plan.

Why is it taking so long when run from a stored procedure? Anyone had this happen to them before? Help?!!

Thanks,
Salaam Received on Thu Apr 11 2002 - 10:15:09 CDT