Re: Query Performance

Don't use index organized on large tables. Read through the docs, they are really only for very special cases. I tried, and it didn't work out real well.

Have you issued a trace either with alter system set sql_trace=true; or
execute sys.dbms_system.set_sql_trace_in_session(sid,serial#,true);

Also, I am not sure what you mean by large, but 6-8 minutes may not be that unreasonable. How often to you do this insert?, is it really worth the time to tune?

--
Robert Fazio, Oracle DBA
rfazio_at_home.com
remove nospam from reply address
http://24.8.218.197/
"Deborah Carter" <dcarter_at_cnfei.com> wrote in message
news:j4xZ4.753$RT3.1291009_at_firenze.visi.net...


> I am working on this project writing a procedure to select information out

> of some rather large tables and insert them into another table.  The

> procedure runs for about 6-8 minutes.  How can I improve this performance?

> I believe my select statements are optimized.  I just don't know what else

> to check or do to speed up the performance.  The query takes so long.  I

 was


> thinking about reorganizing the largest tables as index-organized tables.

> How will this effect performance?  What are the drawbacks to

 index-organized


> tables?  Any suggestions are appreciated.

>

> Deborah Carter

>

>