query tunning
i have a database which through which i connt remotely. but my queries take long time.....
how can i tune the data. please help me in the tunning of these queries....... the queries as follow....
insert into TABS_POSTPAID
select subno,prepost_paid from crm_user_info@HLR2TABS where prepost_paid='POST'and condate <='06-Jul-2009';
and
select subno,prepost_paid from crm_user_info@HLR2TABS
where subno in (select substr (msisdn,5,7) from HLR_POSTPAID) and prepost_paid='PREP'
and subno not in (select substr(msisdn,3,7) from sdp_image_2101 where SERVICECLASS !=230)
and
select * from sdp_image_2101 where msisdn in (
insert into TABS_POSTPAID
select subno,prepost_paid from crm_user_info@HLR2TABS where prepost_paid='POST'and condate <='06-Jul-2009';
and
select subno,prepost_paid from crm_user_info@HLR2TABS
where subno in (select substr (msisdn,5,7) from HLR_POSTPAID) and prepost_paid='PREP'
and subno not in (select substr(msisdn,3,7) from sdp_image_2101 where SERVICECLASS !=230)
and
select * from sdp_image_2101 where msisdn in (
0