SQL help pls

From: KK <krallabandi_at_gmail.com>
Date: 12 Sep 2006 05:53:34 -0700
Message-ID: <1158065614.491067.281450@m73g2000cwd.googlegroups.com>

Can anybody tell me why the following query is taking time to execute when I use in side the loop in stored procedure

                         select count(*) into abcfrom r_output where
                         trim(both from l_name) = cRec.l_name and trim(
both from db) = cRec.db and trim(both from f_id) = cRec.f_id and
                         trim(both from c_id) = cRec.c_id and trim(both
from a_id) = cRec.a_id and trim(both from g_id) = cRec.g_id and
                         trim(both from e_date) = cRec.e_date and

trim(both from t_date) = cRec.t_date and f_key = inFKey and s_f_key = inSFKey;

all variables are of type varchar2 except f_key, s_f_key which are of integer type

Thanks. Received on Tue Sep 12 2006 - 07:53:34 CDT