[AccessD] Speed up this query?

Tried making the server table local and query runs normal. Thanks for the ideas.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Thursday, July 30, 2009 3:34 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Speed up this query?

If not done already, index the join and where fields.

John W. Colby
www.ColbyConsulting.com


Kaup, Chester wrote:
> Any ideas on how to speed up this query other than get a better computer? Table Configmaster is a linked access table on a network drive. Other two tables are native tables on my local C drive. 
> 
> SELECT [tbl Injection Volume Total around a Pattern].Pattern, 
> [tbl Injected Volume Total around Producer].ForecastDate, 
> [tbl Injected Volume Total around Producer].ProducerWellname, 
> [tbl Injected Volume Total around Producer].SumOfRBI AS Inner_Injection_Total, 
> [tbl Injection Volume Total around a Pattern].RBI AS Outer_Injection_Total
> FROM ([tbl Injected Volume Total around Producer] 
> INNER JOIN ConfigMaster ON 
> [tbl Injected Volume Total around Producer].ProducerWellname = ConfigMaster.ChildPID) 
> INNER JOIN [tbl Injection Volume Total around a Pattern] ON (ConfigMaster.PID = [tbl Injection Volume Total around a Pattern].Pattern) AND ([tbl Injected Volume Total around Producer].ForecastDate = [tbl Injection Volume Total around a Pattern].ForecastDate)
> ORDER BY [tbl Injection Volume Total around a Pattern].Pattern, 
> [tbl Injected Volume Total around Producer].ForecastDate, 
> [tbl Injected Volume Total around Producer].ProducerWellname;
> 
> Chester Kaup
> Engineering Technician
> Kinder Morgan CO2 Company, LLP
> Office (432) 688-3797
> FAX (432) 688-3799
> 
>  
> No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced.
> 
> 
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com