I have bunch of following insert statements, each one takes 15 to 20 mins. I want to tune these queries, can anyone explain me all areas I should look into. I already rebuild the indexes, ran the defragmentation etc..
insert into table a
select * from table b where c in(38388,8883883, etc.. like 2500 numbers)
insert into table temp
select * from table tempabc where ab in(73777,66633, like 3000 numbers)