By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,702 Members | 1,771 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,702 IT Pros & Developers. It's quick & easy.

query on multiple queries (no relationship)

P: n/a
Hello,

I created a database containing several queries on 1 table giving as
output the number of records who met certains criteria (= warnings).
1 "grouping" query has as input all the queries (not linked / no
relationship) creating 1 record with the number of warnings per
criteria.

In the past months , i added several new warnings ....
I noticed that the speed of the "grouping" query is becoming very very
slow ...

Does somebody has some tips to increase the speed ?

thanks in advance
Bert
Belgium
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Bert_Belgium wrote:
Hello,

I created a database containing several queries on 1 table giving as
output the number of records who met certains criteria (= warnings).
1 "grouping" query has as input all the queries (not linked / no
relationship) creating 1 record with the number of warnings per
criteria.

In the past months , i added several new warnings ....
I noticed that the speed of the "grouping" query is becoming very very
slow ...

Does somebody has some tips to increase the speed ?


Index some of the columns that are in the WHERE clause of your query.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.