Insert Into - can it work faster

[rtdvoip]

Is there anyway for this to be enhanced so that such a query will run faster in SQL?

----code below----

Insert Into bt_tmp(Clarent_pin,
service_code,
duration,
bill_type,
phone_number,
start_time,
disconnect_reason,
extended_reason_code,
ip_addr_egress,
ip_addr_ingress,
new_call_id,
dest_gateway_id,
source_gateway_id)
Select pin,
service_code,
duration,
bill_type,
phone_number,
start_time,
disconnect_reason,
extended_reason_code,
ip_addr_egress,
ip_addr_ingress,
new_call_id,
dest_gateway_id,
source_gateway_id
from Subscriber.GWUser.Billing_record
where pin in ('dadenegar01','pri','2515436094') and service_code not in ('A','C')
-------code complete-----------------

 

[nigelrivett]

The thing that you will need to optimise is

where pin in ('dadenegar01','pri','2515436094') and service_code not in ('A','C')

is there an index on pin? If not and it wouldn't cause other problems try adding one (depends on your data distribution as to whether it's useful)
If so check that it is being used - if not try updating statistics. If still no then try it with a hint.
If it's still not faster then there is probably not a lot you can do. You could try turning this into a union query but I doubt if it would help.