RE: What do you think works faster?

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Thu, 15 Feb 2001 09:34:57 -0800
Message-ID: <F001.002B56B6.20010215085539@fatcity.com>

I think they look both the same, therefore, either should be just as fast, but bear in mind, if you run proc.sql, then proc1.sql afterwards, it will already be parsed, so proc1.sql will run marginally faster :)

(If they run at all :^) )

You would be much better off pasting the content of the procedures in to your email Viktor, then the list may be able to help, I had noticed that you have not tried any further due to no responses..

Regards

Mark

-----Original Message-----
Sent: Monday, February 12, 2001 04:13
To: Multiple recipients of list ORACLE-L

We've got some dynamic sql proc.

Attached are 2 files.

Which one you think should work faster?

Thanks.

Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark Leith
  INET: mark_at_cool-tools.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Received on Thu Feb 15 2001 - 11:34:57 CST