insert append hint
Saaz EnaSep 27 2011 — edited Sep 27 2011hi all,
can I use below command to improve performance
INSERT /*+ APPEND */ INTO table_name_gp
select * from table_name_phy
where colun_name = 'value_1'
-- where table_name_gp is a global temp table and have index
thanks
saaz
Edited by: Saaz Ena on Sep 27, 2011 9:49 AM