Re: Dynamic SQL performance

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 22 Aug 1998 01:59:58 GMT
Message-ID: <35df1572.606221@netnews.worldnet.att.net>

On Fri, 21 Aug 1998 10:21:29 GMT, lalaina_at_my-dejanews.com wrote:

>What is best in terms of perfomance :
>SQL> @ file_with_truncate_statements.sql
>
>or create a procedure using DBMS_SQL ?

Why not just try both ways an see? Why does it matter, anyway? It can't be that much different. From within an applicaton I would lean towards using DBMS_SQL, because that would probably be much easier then invoking an external executable. If I were doing this from a command file, I would lean towards a SQL*Plus script.

regards,

Jonathan Gennick Received on Fri Aug 21 1998 - 20:59:58 CDT