On Sat, 21 Mar 2015 14:36:47 -0600 Scott Robison <scott at casaderobison.com> wrote:
> On Mar 21, 2015 1:43 PM, "James K. Lowden" <jklowden at schemamania.org> > wrote: > > > > The query optimizer has to be sophisticated enough to recognize > > those conditions, which is unlikely in the case of a temporary > > table. > > Are temporary tables really that different? Other than being dropped > automatically at the end of a session, I was under the impression > they were just another table. They're different to the extent ANALYZE matters. I'm assuming ANALYZE wouldn't be run between the time the temporary table is created and when it's used. --jkl
