Re: Q: is DS 7.x using index?

georget wrote: > > Query looks like: > > SELECT * from table WHERE fld > N> > fld is UNIQUE indexed. > > Pls, help, because performance is dead slow. You can check this yourself. Just "SET EXPLAIN ON;" before running the query then run your query. After it runs look in the file sqexplain.out in the current directory (or in your home directory on the server machine if the server is remote). If it is not using the index you probably need to update statistics. Art S. Kagel