SQL92 query - SQL performance issue running off a PROGRESS DB
Posted on 2006-06-14
I can’t find a PROGRESS database topic area so as the query Im writing is standard SQL I thought someone here could point me in the right direction.
I have a query with major performance issues!!! and any help would be most appreciated
Below is my query.
It uses two LEFT OUTER JOIN - both are necessary.
I have ran an update table and update index statistics scripts before running the query and this has little if no effect.
It is worth noting that we are running off a PROGRESS 9.1E database connecting via ODBC MERANT 3.60 32 Bit Progress SQL92
I'm hoping that my query is just badly written as it is small enough and Im running out of ideas fast!
Also this same query runs fine when running for our smaller departments, but our main departments it crashes on.
SELECT Table_One.Field_A, Table_One.Field_B,
Table_One.Field_D, Table_One.Field_E ,Table_One.Field_F,
Table_One.Field_G, Table_One.Field_H, Table_Two.Field_I, Table_C.Field_J
FROM (PUB.Table_One Table_One
LEFT OUTER JOIN PUB.Table_Three Table_Three
ON (Table_One.Field_B=Table_Three.Field_B) AND (Table_One.Field_G=Table_Three.Field_G))
LEFT OUTER JOIN PUB.Table_Two Table_Two
WHERE Table_One.Field_F='R' AND Table_One.Field_G=39