Slow query when selecting more than one column?

  • Thread starter rashar via AccessMonster.com
  • Start date
R

rashar via AccessMonster.com

Hello,

I have a query that returns 1000+ records, and when I run it selecting 1
column, the rows returned are extremely fast.

If I select more than 1 column in my query, it takes a very long time to
return the dataset. Why is that?

I have my primary key set, ordered by ASC... but I can't figure this one out.

Thanks in advance.
 
J

Jerry Whittle

Show us the SQL. Open the query in design view. Next go to View, SQL View
and copy and past it here.

Information on primary keys such as the field name and relationships, if it
involves more than one table, would be a nice touch too. Also any indexes.

What kind of data types are the other columns?
 
Top