Re: Optimizing JOINS -- related matter

2001-03-08 Thread Jan Dvorak
Hi, I'd try to `optimize' the tables in the first place. Have you tried to select and group by PR1.pollResponsesID instead of PR2.pollResponsesID? As they are the equal, the result should be the same, but the query might get optimized better. Hope this helps, Jan "Oson, Chris M." wrote: >

Optimizing JOINS -- related matter

2001-03-08 Thread Oson, Chris M.
Hello, On a related matter, do the various JOIN's (LEFT, INNER, and OUTER) use a temp file when processing? Table pollResponses: +-+---+--+-+-++ | Field | Type | Null | Key | Default | Extra | +-