Hi everyone,

I have 2 index file and I use SQL select to make a query but they don't optimize (I check with sys(3054,1)), here is my code :

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 tmp

Anyone 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)

TIA,

Budianto