How do I speed up the quey performance if I've a query like this :<br /> Does '<u><big>not in</big></u>' command will
affectedthe performance?.<br /><br /> select
ts.transportid,ts.transporttype,ts.transportcapacity,ts.transportstatus,ts.routecoverage,ts.transportregnumber<br />
from transportsetup ts<br /> where ts.bizid = 'B126' <br /> and ts.deletestatus = 0 <br /> and
ts.transportid<u><big>not in</big></u> ( select t.transportid <br />
f rom transportsetup t,servicedetail s,logisticservice l <br />
wheret.bizid=l.bizid <br /> and l.serviceid=s.serviceid <br />
and t.transportid=s.transportid <br />
and t.bizid = 'B126' <br /> and
l.status='Pending'<br/> or t.bizid=l.bizid <br />
and l.serviceid=s.serviceid <br />
and t.transportid=s.transportid <br /> and t.bizid = 'B126' and
l.status='Reserved') <br /> order by ts.transporttype;<br /><br /><br /> Any help pretty much appreciated. Thanks<br />