Procedure Performance Suggestion

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 - 10:00:25 CST