Vladimir, can you send me the structure, indexes and your SELECT statement Arnon > Hello Arnon! > > This table is already sorted, but the time of selecting is so slow ;( And, > remember, that my query is partially optimized. I tried examples from VFP > help that was claimed as fully optimized and get the same results: > partially or none optimization ;) It's very strange thing. > > Have a happy day > Vladimir Shevchenko > > > I can understand why it can take VFP long to copy 800,000 records to a > new > > temporary table > > static data then you might consider SORTing the table on the Indexkey it > > can lower the retrieve time dramatically > > > > Arnon > > > > >Hello Arnon! > > > > > >This query may return from 100 till 700-800 thousand records. Don't > think > > >that it's bad programming style, just testing of Rushmore power > against >