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