In my server there are two databases. i want to select record with some conditons from 1'st db and then insert that records in to the second db. but the select record contains near 2 lacs. the query i was written takes much more time (near 2-3 minutes). how can i reduce that.. thanks in advance.