Slow query when selecting more than one column?

  • Thread starter Thread starter rashar via AccessMonster.com
  • Start date 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.
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problems with Crosstab Query 4
mulltiple column "not in" query 6
query which selects data at an intersection 9
differents results from the same query execution 2
Like query slow on number field 12
Access 2010 append query to SQL is very slow 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
query return only one row with averages 4

Back
Top