Re: Procedure Performance Suggestion

From: Richard Kuhler <noone_at_nowhere.com>
Date: Fri, 22 Mar 2002 17:50:57 GMT
Message-ID: <5aKm8.5818$Q2.1281711@twister.socal.rr.com>

1000 rows shouldn't take much time at all. Have a look at the APPEND hint though.

Richard

R Chin wrote:
>
> I have a procedure that builds the SELECT and uses Native Dyn. SQL (execute
> immediate) to populate a table for report....
> 1) if the table NOT exist, do CTAS...(nologging)
> 2) if it exists, TRUNCATE it, and do INSERT...SELECT
> (table size about < 1000 rows)
>
> To get any performance gain....should I just DROP the table
> and do CTAS as opposed to #2 ??
>
> Thanks !
> Rob
Received on Fri Mar 22 2002 - 11:50:57 CST