Re: [SQL] index/join madness

2001-05-23 Thread Tom Lane
"Michael Richards" <[EMAIL PROTECTED]> writes: > [ a severely incomplete problem description ] Table schema? Full text of the query? > It has one index defined on: > Index "formdata_pkey" > Attribute | Type > ---+- > formid| integer > occid | integer > userid

Re: [SQL] index/join madness

2001-05-23 Thread David Olbersen
On Wed, 23 May 2001, Michael Richards wrote: > Finally, I'm planning on moving this to 7.2 and converting all the > joins to use outer joins. Will there be a significant penalty in > performance running outer joins? Why are you planning on using outer joins? Yes there is a performance penalty be