query's slow

L

LOA

when I run a query on data base it's very slow; whe I run other query in the
same data base the speed is normal, what can i do?

thanks.
 
L

LOA

i forgot post SQL:

SELECT [captura 1].año, [captura 1].mes, [captura 1].calibre, [captura
1].prensa, [captura 1].dado, [captura 1].terminal, (calibres!maxima-[captura
1]!AvgOflectura)/(3*[captura 1]!StDevOflectura) AS PPU, ([captura
1]!AvgOflectura-calibres!minima)/(3*[captura 1]!StDevOflectura) AS PPL
FROM [captura de pull test] INNER JOIN (calibres INNER JOIN [captura 1] ON
calibres.calibre = [captura 1].calibre) ON [captura de pull test].calibre =
calibres.calibre
GROUP BY [captura 1].año, [captura 1].mes, [captura 1].calibre, [captura
1].prensa, [captura 1].dado, [captura 1].terminal, (calibres!maxima-[captura
1]!AvgOflectura)/(3*[captura 1]!StDevOflectura), ([captura
1]!AvgOflectura-calibres!minima)/(3*[captura 1]!StDevOflectura);

I hope that someone help me!!!!
 
T

Tom Wickerath

Hi LOA,

Here is a KB article with tips that you might find helpful:

Information about query performance in an Access database
http://support.microsoft.com/?id=209126

You might also try experimenting with JET ShowPlan, as detailed in this
article:
http://builder.com.com/5100-6388-5064388.html


If my answer has helped you, please answer yes to the question that reads
"Did this post answer the question?" at the bottom of the message thread.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

i forgot post SQL:

SELECT [captura 1].año, [captura 1].mes, [captura 1].calibre, [captura
1].prensa, [captura 1].dado, [captura 1].terminal, (calibres!maxima-[captura
1]!AvgOflectura)/(3*[captura 1]!StDevOflectura) AS PPU, ([captura
1]!AvgOflectura-calibres!minima)/(3*[captura 1]!StDevOflectura) AS PPL
FROM [captura de pull test] INNER JOIN (calibres INNER JOIN [captura 1] ON
calibres.calibre = [captura 1].calibre) ON [captura de pull test].calibre =
calibres.calibre
GROUP BY [captura 1].año, [captura 1].mes, [captura 1].calibre, [captura
1].prensa, [captura 1].dado, [captura 1].terminal, (calibres!maxima-[captura
1]!AvgOflectura)/(3*[captura 1]!StDevOflectura), ([captura
1]!AvgOflectura-calibres!minima)/(3*[captura 1]!StDevOflectura);

I hope that someone help me!!!!
__________________________________________

:

when I run a query on data base it's very slow; whe I run other query in the
same data base the speed is normal, what can i do?

thanks.
 
Top