Re: Access Speed with Informix

Yan, One more important point. Access queries cannot use ordinary Informix made indexes that start with the space character. If so, the query will try a sequential scan - not what you'd want. You need to create your own indexes on the tables you customarily query and give them names that do not begin with the space character. Yours, Nick >At 05:37 PM 2/15/98 -0500, you wrote: >>hi: >> I have a one gig table sitting on a informix server on a unix box. I >>linked a table in Ms Access in my Win95. When I did a query on it, it >>took forever to come back, in fact it never did, Access actually blanked >>out when the query ran, I got impatient and end the task. Is that normal >>or am I doing something wrong? >> >> The query should have picked up around 10,000 records. >> >> Thanks. >> >>yan >> >> ********************* Nick Nobbe NLS/BPH Library of Congress nnob@loc.gov