query optimize

Hi, How can I optimize the informix query below- the query uses an OUTER join... select col1, col2, '' col3, col4, A.col5, A.col6, count(*) cout from table A, table B, table C, OUTER table D where A.col9 = B.col9 and A.col7 = D.col7 and A.col8 = 'Y' and B.col1 = c.d and D.col8 = 'Y' group by 1,2,3,4,5,6; Thanks, Jernd

devaraj.takhellambam@gmail.com said: > Hi, > > How can I optimize the informix query below- the query uses an OUTER > join... > > > select col1, col2, '' col3, col4, A.col5, A.col6, > count(*) cout > from table A, table B, table C, OUTER table D > where A.col9 = B.col9 and > A.col7 = D.col7 and > A.col8 = 'Y' and > B.col1 = c.d and > D.col8 = 'Y' > group by 1,2,3,4,5,6; Why do you believe it needs optimising? -- Bye now, Obnoxio "I don't read newspapers anymore except the local rag which I do weekly to cheer myself trying to see if anyone I hate has been stabbed." -- Horribilis XVI -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.