[AccessD] Speed up this query?

Kaup, Chester Chester_Kaup at kindermorgan.com
Thu Jul 30 15:22:13 CDT 2009


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.





More information about the AccessD mailing list