sele 1 use customer inde cust1.idx && inde on cust_id sele 2 use sales inde sales1.idx && inde on cust_id sele s.cust_id,c.cust_name,s.sales_qty from customer c, sales s where s.cust_id=c.cust_id order by s.cust_id into cursor tmpAnyone knows why this is happend and also it doesn't optimize if I have more than one field on index file (i.e : inde on cust_id+cust_name to idxname)