On Sun, Mar 22, 2015 at 2:47 PM, James K. Lowden <jklowden at schemamania.org> wrote:
> On Sat, 21 Mar 2015 14:36:47 -0600 > Scott Robison <scott at casaderobison.com> 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. > Good point. Thanks. -- Scott Robison
