hi
I have the following query, whcih is very fast enough in select the data but the same qry if i put to isert into a temp table it is taking lot of time.the total no of records is 87000 from select statement.
pl help me in this query.

index are there on purchase_log table.


INSERT INTO temp_transd1(bt_option,bt_trno,bt_seqno,bt_processdt,bt_units,bt_agent,bt_purred,bt_acno)
SELECT pl.fund_option,pl.txn_no,SEQ_NO,pl.batch_run_date,pl.units_allotted,pl.distributor_id,
pl.txn_source,pl.account_number
FROM purchase_log pl
WHERE pl.distributor_id =Trim(o_brokcode)
AND pl.auth_date <=i_trdate
AND pl.txn_status <> 'R' ;



thnks
sk_naidu