improve the perfomance?

[du sixiang]

select c.cus_cust_no,sum(o.totalpay) as sum_total from customer c,orders v where c.cus_cust_no=v.ord_cust_no ;
the sql String can perfom,but the velocity is so so slowly...?
how can i do something to improve it ?