Hello!
I have a table setup in a SQL Server 7.0 database with 1.5 million records. Doing a very simple query, on an indexed field, in the Query Analyzer on the server machine itself, seems very slow. -Considerably slower than running the same query on a VFP table on the same machine. I'm talking about 27 seconds for a return of 12,000 records from a query like:

SELECT MyField FROM MyDBC.dbo.MyTable WHERE MyField = 'MyValue'

There is an index on MyField.
The statistics report usually shows about 23 logical reads.

There has to be something I'm doing wrong. Any suggestions would be very appreciated!
Mark