fast loading

Hi, I am using insert into table2 select * from table1. Is there a way to temporarily disable indicies on table2 when doing the above. The objective is to increase the speed of loading. TIA.

In the year of Our Lord 4 Jan 2001 04:51:08 -0800, triggerfish2001@hotmail.com broke a vow of silence to utter: >I am using insert into table2 select * from table1. > >Is there a way to temporarily disable indicies on table2 >when doing the above. The objective is to increase the >speed of loading. SET INDEXES FOR table2 DISABLED; insert into table2 select * from table1;SET INDEXES FOR table2 ENABLED;