I am wondering if there is any trick (or tips) for how to deal with the following scenario:
We have a CUSTOMER table that has 360000+ records. It is a DBF and has a CDX index file.
In NetBeans IDE, under Services tab, I've added the table and execute the following statement: SELECT [name],custno,contact FROM CUSTOMER WHERE CUSTNO > '92000'; It takes several minutes to display the results.
I am wondering if you know of a way(query?) that I can perhaps utilize the existing CDX index to perform that operation faster? Or is it already using it by default?
Run once "create index abc of abc.cdx on CUSTOMER (custno);";
Then check whether your query be quicken.