Re: Dynamic SQL performance

From: Nicholas Botes <nic-mic_at_worldnet.att.net>
Date: 22 Aug 1998 02:50:41 GMT
Message-ID: <6rlbm1$hr4@bgtnsc01.worldnet.att.net>

We use Dinamis SQl and found it a lot faster in execution as most of the code is 'compiled'.

There are some costly operation to lookout for like opening and closing cursors - Reuse them !!

Thanks

....
lalaina_at_my-dejanews.com wrote in message <6rjhn8$uh5$1_at_nnrp1.dejanews.com>...
>Hello Oracle users ,
>
>I was wondering about the performance of DBMS_SQL package.
>My application starts by truncating a set of tables.
>
>What is best in terms of perfomance :
>SQL> @ file_with_truncate_statements.sql
>
>or create a procedure using DBMS_SQL ?
>
>Within our team, views are divergent on the topic.
>Could you help us ?
>
>Thanks,
>
>Lalaina
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Fri Aug 21 1998 - 21:50:41 CDT