Re: Join with two columns - Performance

Posted in 1995

Sally Woolrich — Wed, 21 Jun 95 10:56:01 GMT — source: Informix-list mailing list archive (1991-1998)

In article <45a2ebf5@aventure.teuto.de> kai_stuke@aventure.teuto.de "Kai Stuke" writes: > I'm having severe performance problems with a seemingly simple select of > the form > > select * from a, b where a.a1 = b.b1 and a.a2 = b.b2> This should work fine if i) there are indices on a(a1, a2) AND b(b1, b2). Have you tried 'SET EXPLAIN ON' and 'UPDATE STATISTICS'? -- ============================================================================ Sally Woolrich | This mail contains my personal sally@excelsis.demon.co.uk | views not those of my employer! ============================================================================