[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.
> 
>